APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on FND_LANGUAGES

Line 3157: FROM fnd_languages

3153: WHERE b.extension_id = tl.extension_id);
3154:
3155: SELECT language_code
3156: INTO l_base_lang
3157: FROM fnd_languages
3158: WHERE installed_flag ='B';
3159:
3160:
3161: DELETE FROM po_headers_all_ext_tl phaet

Line 3220: fnd_languages l

3216: b.creation_date ,
3217: b.uda_template_id,
3218: p_draft_id
3219: FROM po_headers_all_ext_b b,
3220: fnd_languages l
3221: WHERE b.extension_id = l_entension_id_tbl(i)
3222: AND l.installed_flag IN ('B', 'I')
3223: ;
3224:

Line 5162: l_cd_territory fnd_languages.iso_territory%TYPE;

5158: x_progress varchar2(1000);
5159: l_request_id number;
5160: l_revision_number NUMBER;
5161: l_template_code po_print_form_formats.DOC_FORMAT_TMPL_CODE%TYPE;
5162: l_cd_territory fnd_languages.iso_territory%TYPE;
5163: l_lang_code fnd_languages.language_code%TYPE;
5164: l_application_name VARCHAR(2):= 'PO';
5165: BEGIN
5166:

Line 5163: l_lang_code fnd_languages.language_code%TYPE;

5159: l_request_id number;
5160: l_revision_number NUMBER;
5161: l_template_code po_print_form_formats.DOC_FORMAT_TMPL_CODE%TYPE;
5162: l_cd_territory fnd_languages.iso_territory%TYPE;
5163: l_lang_code fnd_languages.language_code%TYPE;
5164: l_application_name VARCHAR(2):= 'PO';
5165: BEGIN
5166:
5167: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: 01';

Line 5202: from po_print_form_formats pf, po_drafts h, po_headers_all h1, fnd_languages f

5198:
5199:
5200: select pf.DOC_FORMAT_TMPL_CODE, f.iso_territory, f.language_code
5201: into l_template_code,l_cd_territory,l_lang_code
5202: from po_print_form_formats pf, po_drafts h, po_headers_all h1, fnd_languages f
5203: where pf.FORM_SOURCE = 'PO' and pf.DOCUMENT_TYPE = 'PO_MOD_STD_FORM' and pf.STANDARD_FORM = h.CLM_STANDARD_FORM
5204: and pf.DOCUMENT_FORMAT = h.CLM_DOCUMENT_FORMAT and h1.po_header_id = h.document_id
5205: and pf.STYLE_ID = h1.STYLE_ID and h.draft_id = l_draft_id and f.language_code = USERENV('LANG');
5206: