lang::catalog::all_messages_for_package_and_locale (private)

 lang::catalog::all_messages_for_package_and_locale package_key locale

Defined in packages/acs-lang/tcl/lang-catalog-procs.tcl

Set a multirow with name all_messages locally in the callers scope with the columns message_key and message for all message keys that do not have an upgrade status of deleted.

Parameters:

package_key (required)

locale (required)

Author:

Peter Marklund

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    return [db_list_of_lists get_messages {}]

Generic XQL file:

<fullquery name="lang::catalog::all_messages_for_package_and_locale.get_messages">
    <querytext>
        select lm.message_key, 
               lm.message, 
               lmk.description
        from   lang_messages lm,
               lang_message_keys lmk
        where  lm.message_key = lmk.message_key
        and    lm.package_key = lmk.package_key
        and    lm.package_key = :package_key
        and    lm.locale = :locale
        and    lm.deleted_p = 'f'
    </querytext>
</fullquery>

packages/acs-lang/tcl/lang-catalog-procs.xql

PostgreSQL XQL file:

packages/acs-lang/tcl/lang-catalog-procs-postgresql.xql

Oracle XQL file:

packages/acs-lang/tcl/lang-catalog-procs-oracle.xql