DBA Data[Home] [Help]

APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on STANDARD

Line 100: 'STANDARD', 'PO',

96: -- TBD need call po_draf_merge procedure
97: log_debug('system_reject_mod : Begin ');
98: SELECT po_header_id,
99: decode(type_lookup_code,
100: 'STANDARD', 'PO',
101: 'BLANKET', 'PA',
102: 'CONTRACT', 'PA', null),
103: type_lookup_code,
104: created_by

Line 5203: where pf.FORM_SOURCE = 'PO' and pf.DOCUMENT_TYPE = 'PO_MOD_STD_FORM' and pf.STANDARD_FORM = h.CLM_STANDARD_FORM

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:
5207: --Submitting concurrent program 'Generate Change Description'