APPS.PO_MOD_SYNC_PROCESS_PVT dependencies on PO_HEADERS_ALL_EXT_TL

Line 3152: FROM po_headers_all_ext_tl tl

3148: FROM po_headers_all_ext_b b
3149: WHERE draft_id = p_draft_id
3150: AND po_header_id = l_po_header_id
3151: AND NOT EXISTS (SELECT 'tl table record exists'
3152: FROM po_headers_all_ext_tl tl
3153: WHERE b.extension_id = tl.extension_id);
3154:
3155: SELECT language_code
3156: INTO l_base_lang

Line 3161: DELETE FROM po_headers_all_ext_tl phaet

3157: FROM fnd_languages
3158: WHERE installed_flag ='B';
3159:
3160:
3161: DELETE FROM po_headers_all_ext_tl phaet
3162: WHERE phaet.po_header_id=l_po_header_id
3163: AND phaet.draft_id = p_draft_id
3164: AND EXISTS (SELECT 'if multi row attr grp'
3165: FROM ego_fnd_dsc_flx_ctx_ext ag

Line 3181: INSERT INTO po_headers_all_ext_tl tl

3177: AND phb.c_ext_attr40 = 'PO_UDA_ADDRESS_TYPES'
3178: );
3179:
3180: FORALL i IN 1 .. l_entension_id_tbl.COUNT
3181: INSERT INTO po_headers_all_ext_tl tl
3182: ( tl.extension_id,
3183: tl.attr_group_id,
3184: tl.po_header_id,
3185: tl.source_lang,

Line 3227: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_tl for S or No locks');

3223: ;
3224:
3225: d_position :=70;
3226: IF (PO_LOG.d_stmt) THEN
3227: PO_LOG.stmt(d_module,d_position ,'Updated po_headers_all_ext_tl for S or No locks');
3228: PO_LOG.stmt(d_module,d_position ,'number of rows Updated ',SQL%ROWCOUNT);
3229: END IF;
3230:
3231: d_position := 80;