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
locale
Author:
Peter Marklund

Partial Call Graph (max 5 caller/called nodes):
%3 lang::catalog::export lang::catalog::export (public) lang::catalog::all_messages_for_package_and_locale lang::catalog::all_messages_for_package_and_locale lang::catalog::export->lang::catalog::all_messages_for_package_and_locale lang::catalog::messages_in_db lang::catalog::messages_in_db (private) lang::catalog::messages_in_db->lang::catalog::all_messages_for_package_and_locale

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

[ hide source ] | [ make this the default ]
Show another procedure: