APPS.PO_EDA_DATATEMPLATE_PKG dependencies on PO_ENTITY_DIFFERENCES

Line 860: po_gen_diff_pkg.delete_differences('AWARD','ALL','PO_ENTITY_DIFFERENCES',NULL,NULL,NULL,NULL,NULL,DOCUMENTID,DRAFTID,NULL,NULL,NULL);

856:
857:
858: BEGIN
859:
860: po_gen_diff_pkg.delete_differences('AWARD','ALL','PO_ENTITY_DIFFERENCES',NULL,NULL,NULL,NULL,NULL,DOCUMENTID,DRAFTID,NULL,NULL,NULL);
861: po_gen_diff_pkg.find_differences('AWARD','ALL','PO_ENTITY_DIFFERENCES',DOCUMENTID,-1,NULL,NULL,NULL,DOCUMENTID,DRAFTID,NULL,NULL,NULL);
862:
863: RETURN (true);
864: END;

Line 861: po_gen_diff_pkg.find_differences('AWARD','ALL','PO_ENTITY_DIFFERENCES',DOCUMENTID,-1,NULL,NULL,NULL,DOCUMENTID,DRAFTID,NULL,NULL,NULL);

857:
858: BEGIN
859:
860: po_gen_diff_pkg.delete_differences('AWARD','ALL','PO_ENTITY_DIFFERENCES',NULL,NULL,NULL,NULL,NULL,DOCUMENTID,DRAFTID,NULL,NULL,NULL);
861: po_gen_diff_pkg.find_differences('AWARD','ALL','PO_ENTITY_DIFFERENCES',DOCUMENTID,-1,NULL,NULL,NULL,DOCUMENTID,DRAFTID,NULL,NULL,NULL);
862:
863: RETURN (true);
864: END;
865:

Line 876: FROM po_entity_differences

872: Decode(mod_value,NULL,'Deleted','Modified')) ChangeFlag,
873: Decode(orig_value,NULL,Decode(mod_value,NULL,'No Change','New value '''||Nvl(mod_value_desc,mod_value)||''' Added'),
874: Mod_value,'No Change',
875: Decode(mod_value,NULL,'value '''||Nvl(orig_value_desc,orig_value)||''' Deleted','Value modified from '''||Nvl(orig_value_desc,orig_value)||''' to '''||Nvl(mod_value_desc,mod_value)||'''')) ChangeText
876: FROM po_entity_differences
877: WHERE MOD_DOC_PK1_VAL = DOCUMENTID
878: AND MOD_DOC_PK2_VAL = DRAFTID
879: AND Nvl(MOD_DOC_PK3_VAL,-1) = Nvl(p_line_id,-1)
880: AND Nvl(MOD_DOC_PK4_VAL,-1) = Nvl(p_line_location_id,-1)

Line 886: FROM po_entity_differences

882: AND column_name = p_column_name;
883:
884: CURSOR c_ele_exists is
885: SELECT 'Y'
886: FROM po_entity_differences
887: WHERE MOD_DOC_PK1_VAL = DOCUMENTID
888: AND MOD_DOC_PK2_VAL = DRAFTID
889: AND Nvl(MOD_DOC_PK3_VAL,-1) = Nvl(p_line_id,-1)
890: AND Nvl(MOD_DOC_PK4_VAL,-1) = Nvl(p_line_location_id,-1)

Line 969: FROM po_entity_differences

965: Decode(orig_value,NULL,Decode(mod_value,NULL,'No Change','New value '''||Nvl(mod_value_desc,mod_value)||''' Added'),
966: Mod_value,'No Change',
967: Decode(mod_value,NULL,'value '''||Nvl(orig_value_desc,orig_value)||''' Deleted','Value modified from '''||
968: Nvl(orig_value_desc,orig_value)||''' to '''||Nvl(mod_value_desc,mod_value)||'''')) ChangeText
969: FROM po_entity_differences
970: WHERE MOD_DOC_PK1_VAL = DOCUMENTID
971: AND MOD_DOC_PK2_VAL = DRAFTID
972: AND Nvl(MOD_DOC_PK3_VAL,-1) = Nvl(p_line_id,-1)
973: AND Nvl(MOD_DOC_PK4_VAL,-1) = Nvl(p_line_location_id,-1)

Line 2702: FROM po_entity_differences a,po_diff_config b

2698: WHEN 'QTY_PRICING' THEN 'Quantity Pricing'
2699: WHEN 'SOURCE_DOC' THEN 'Sourcing document'
2700: ELSE SUB_ENTITY_NAME
2701: END ) AS entityName
2702: FROM po_entity_differences a,po_diff_config b
2703: WHERE a.ENTITY_NAME IN ('LINE','LINELOCATION','DISTRIBUTION')
2704: AND a.DOCUMENT_TYPE=b.DOCUMENT_TYPE AND a.ENTITY_NAME=b.ENTITY_NAME AND a.MOD_DOC_SOURCE_NAME =b.MOD_DOC_SOURCE_NAME
2705: AND a.COLUMN_NAME=b.COLUMN_NAME
2706: AND MOD_DOC_PK1_VAL = DOCUMENTID

Line 2829: WHERE EXISTS (SELECT 1 FROM PO_ENTITY_DIFFERENCES

2825: BEGIN
2826: SELECT 'Y'
2827: INTO v_vendor_change_flag
2828: FROM dual
2829: WHERE EXISTS (SELECT 1 FROM PO_ENTITY_DIFFERENCES
2830: WHERE MOD_DOC_PK1_VAL = DOCUMENTID AND MOD_DOC_PK2_VAL = DRAFTID
2831: AND DIFF_ID IN (SELECT DISTINCT DIFF_CONFIG_ID
2832: FROM po_diff_config
2833: WHERE SUB_ENTITY_NAME = 'SUPPLIER_DTLS'));