[Home] [Help]
311:
312: IF p_document_type IN ('AWARD','IDV') THEN
313: FORALL i in 1 .. base_pk1_value_tbl.count
314:
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),
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
637:
638: --
639: /* ========================================================================================
640: NAME: generate_par_differences
641: DESC: populates po_entity_differences with the changes done to par wrt the entities revison
642: ===========================================================================================*/
643: PROCEDURE generate_par_differences(p_document_type VARCHAR2,
644: base_pk1_value NUMBER,
645: base_pk2_value NUMBER,
760: l_progress := '0060';
761:
762: FORALL i in 1 .. base_pk1_value_tbl.count
763:
764: INSERT INTO po_entity_differences (
765: diff_id,
766: document_type,
767: entity_name,
768: mod_doc_source_name,
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',
1466: mod_pk2_value => l_par_draft_id,
1467: mod_pk3_value => NULL,
1468: mod_pk4_value => NULL,
1469: mod_pk5_value => NULL,
1470: dest_table_name => 'PO_ENTITY_DIFFERENCES');
1471:
1472: resultout := wf_engine.eng_completed;
1473:
1474: l_progress := 'PO_GEN_DIFF_PKG.generate_par_differences_wf End';