APPS.PO_AUTOCREATE_PVT dependencies on PO_ENTITY_DIFFERENCES

Line 643: (SELECT * FROM po_entity_differences WHERE mod_doc_source_name = 'PO_ADDRESSES_DRAFT_DIFF_V') ped

639: BULK collect
640: INTO p_attr_display_name
641: FROM (SELECT * FROM ego_attrs_v WHERE attr_group_type = 'PO_HEADER_EXT_ATTRS') eav,
642: (SELECT * FROM ego_attr_groups_v WHERE attr_group_name = 'addresses') eagv ,
643: (SELECT * FROM po_entity_differences WHERE mod_doc_source_name = 'PO_ADDRESSES_DRAFT_DIFF_V') ped
644: WHERE eav.attr_group_name = eagv.attr_group_name
645: AND eav.attr_group_type = eagv.attr_group_type
646: AND SubStr(ped.column_name, InStr(ped.column_name, Chr(0))+1) = eav.attr_name
647: AND mod_doc_pk2_val = p_par_draft_id;

Line 762: FROM po_entity_differences

758:
759: --select distinct address type
760: SELECT DISTINCT SubStr(column_name, 1,InStr(column_name,'_'||Chr(0))-1) add_type
761: BULK COLLECT INTO l_address_type_tbl
762: FROM po_entity_differences
763: WHERE mod_doc_pk2_val = p_par_draft_id
764: and mod_doc_source_name = p_mod_doc_source_name ;
765:
766:

Line 783: FROM po_entity_differences

779:
780: SELECT SubStr(column_name, InStr(column_name, Chr(0))+1) attr_name, mod_value
781: BULK COLLECT INTO
782: l_attr_name_tbl, l_mod_value_tbl
783: FROM po_entity_differences
784: WHERE mod_doc_pk2_val = p_par_draft_id
785: AND mod_doc_pk1_val = p_pk1_value
786: and mod_doc_source_name = p_mod_doc_source_name
787: AND column_name LIKE l_address_type_tbl(i) ||'%' ;

Line 953: FROM po_entity_differences

949: SELECT DISTINCT SubStr(column_name, 1,InStr(column_name,'_'||Chr(0))-1) attr_group_name,
950: SubStr(column_name, InStr(column_name, Chr(0))+1) attr_name, mod_value
951: BULK COLLECT INTO
952: l_attr_grp_tbl, l_attr_name_tbl, l_mod_value_tbl
953: FROM po_entity_differences
954: WHERE mod_doc_pk2_val = p_par_draft_id
955: AND mod_doc_pk1_val = p_pk1_value
956: AND mod_doc_source_name = p_mod_doc_source_name
957: ORDER BY attr_group_name,attr_name,mod_value ;

Line 965: FROM po_entity_differences

961: SELECT DISTINCT SubStr(column_name, 1,InStr(column_name,'_'||Chr(0))-1) attr_group_name,
962: SubStr(column_name, InStr(column_name, Chr(0))+1) attr_name, mod_value
963: BULK COLLECT INTO
964: l_attr_grp_tbl, l_attr_name_tbl, l_mod_value_tbl
965: FROM po_entity_differences
966: WHERE mod_doc_pk2_val = p_par_draft_id
967: AND mod_doc_pk3_val = p_pk1_value
968: AND mod_doc_source_name = p_mod_doc_source_name
969: ORDER BY attr_group_name,attr_name,mod_value ;

Line 977: FROM po_entity_differences

973: SELECT DISTINCT SubStr(column_name, 1,InStr(column_name,'_'||Chr(0))-1) attr_group_name,
974: SubStr(column_name, InStr(column_name, Chr(0))+1) attr_name, mod_value
975: BULK COLLECT INTO
976: l_attr_grp_tbl, l_attr_name_tbl, l_mod_value_tbl
977: FROM po_entity_differences
978: WHERE mod_doc_pk2_val = p_par_draft_id
979: AND mod_doc_pk4_val = p_pk1_value
980: AND mod_doc_source_name = p_mod_doc_source_name
981: ORDER BY attr_group_name,attr_name,mod_value ;