DBA Data[Home] [Help]

APPS.PO_GEN_DIFF_PKG dependencies on PO_ENTITY_DIFFERENCES_S

Line 319: values(PO_ENTITY_DIFFERENCES_S.nextval, p_document_type, p_entity_name, mod_doc_source, base_pk1_value_tbl(i), base_pk2_value_tbl(i),

315: INSERT INTO po_entity_differences (diff_id, document_type, entity_name, mod_doc_source_name, base_doc_pk1_val, base_doc_pk2_val,
316: base_doc_pk3_val, base_doc_pk4_val, base_doc_pk5_val, mod_doc_pk1_val, mod_doc_pk2_val,
317: mod_doc_pk3_val, mod_doc_pk4_val, mod_doc_pk5_val, column_name, mod_value, orig_value,
318: mod_value_desc, orig_value_desc, creation_date, created_by, last_update_date, last_updated_by)
319: values(PO_ENTITY_DIFFERENCES_S.nextval, p_document_type, p_entity_name, mod_doc_source, base_pk1_value_tbl(i), base_pk2_value_tbl(i),
320: base_pk3_value_tbl(i), base_pk4_value_tbl(i), base_pk5_value_tbl(i), mod_pk1_value_tbl(i), mod_pk2_value_tbl(i),
321: mod_pk3_value_tbl(i), mod_pk4_value_tbl(i), mod_pk5_value_tbl(i), l_colname_tbl(i), l_newvalue_tbl(i),
322: l_oldvalue_tbl(i), l_newvalue_desc_tbl(i), l_oldvalue_desc_tbl(i), sysdate, l_current_user_id, sysdate, l_current_user_id);
323: ELSIF p_document_type IN ('SOL') THEN

Line 787: PO_ENTITY_DIFFERENCES_S.nextval,

783: created_by,
784: last_update_date,
785: last_updated_by)
786: VALUES (
787: PO_ENTITY_DIFFERENCES_S.nextval,
788: p_document_type,
789: Decode(l_entity_tbl(i), 'PO_HEADERS' , 'HEADER',
790: 'PO_LINES' , 'LINE',
791: 'PO_LINELOCS' , 'LINELOCATION',