DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on WF_LANGUAGES

Line 5938: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;

5934: l_seq_for_item_key varchar2(25);
5935: l_itemkey varchar2(60);
5936: l_workflow_process po_document_types.wf_approval_process%type;
5937: l_itemtype po_document_types.wf_approval_itemtype%type;
5938: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
5939: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
5940: l_po_email_performer WF_USERS.NAME%TYPE;
5941: l_email_address WF_USERS.NAME%TYPE;
5942: l_display_name WF_USERS.DISPLAY_NAME%TYPE;

Line 5939: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;

5935: l_itemkey varchar2(60);
5936: l_workflow_process po_document_types.wf_approval_process%type;
5937: l_itemtype po_document_types.wf_approval_itemtype%type;
5938: l_adhocuser_lang WF_LANGUAGES.NLS_LANGUAGE%TYPE;
5939: l_adhocuser_territory WF_LANGUAGES.NLS_TERRITORY%TYPE;
5940: l_po_email_performer WF_USERS.NAME%TYPE;
5941: l_email_address WF_USERS.NAME%TYPE;
5942: l_display_name WF_USERS.DISPLAY_NAME%TYPE;
5943: l_performer_exists number;

Line 5978: FROM wf_languages wfl,

5974: BEGIN
5975: SELECT wfl.nls_language,
5976: wfl.nls_territory
5977: INTO l_adhocuser_lang, l_adhocuser_territory
5978: FROM wf_languages wfl,
5979: fnd_languages_vl flv
5980: WHERE wfl.code = flv.language_code
5981: AND flv.installed_flag = 'B';
5982: