APPS.PO_AUTOCREATE_PVT dependencies on PO_HEADERS_EXT_DRAFT_DIFF_V

Line 729: IF p_mod_doc_source_name = 'PO_HEADERS_EXT_DRAFT_DIFF_V'

725:
726: --Check the entity level and assign the datalevel
727: -- and attr group anme accordingly
728:
729: IF p_mod_doc_source_name = 'PO_HEADERS_EXT_DRAFT_DIFF_V'
730: OR p_mod_doc_source_name = 'PO_ADDRESSES_DRAFT_DIFF_V'THEN
731: l_attr_group_type := 'PO_HEADER_EXT_ATTRS';
732: l_data_level := 'PO_HEADER';
733:

Line 947: IF p_mod_doc_source_name = 'PO_HEADERS_EXT_DRAFT_DIFF_V' THEN

943:
944: ELSE
945: -- For UDA attributes other than addresses
946:
947: IF p_mod_doc_source_name = 'PO_HEADERS_EXT_DRAFT_DIFF_V' THEN
948:
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

Line 1016: IF p_mod_doc_source_name = 'PO_HEADERS_EXT_DRAFT_DIFF_V' THEN

1012: -- : Removing the code as part of clean up
1013:
1014: --Collect the missing entries
1015:
1016: IF p_mod_doc_source_name = 'PO_HEADERS_EXT_DRAFT_DIFF_V' THEN
1017: --
1018: --Collecting data for all such attributes that need to be copied from PAR
1019: WITH ag_data AS (
1020: SELECT SubStr(col_name, 1,InStr(col_name,'_'||Chr(0))-1) attr_grp_name,

Line 1023: FROM po_headers_ext_draft_diff_v

1019: WITH ag_data AS (
1020: SELECT SubStr(col_name, 1,InStr(col_name,'_'||Chr(0))-1) attr_grp_name,
1021: SubStr(col_name, InStr(col_name, Chr(0))+1) attr_name ,
1022: col_value col_value
1023: FROM po_headers_ext_draft_diff_v
1024: WHERE col_value IS NOT NULL
1025: ) --Collecting the attribute grp name, aatribute name and their value in ag_data
1026: SELECT ag_data.attr_grp_name, ag_data.attr_name, ag_data.col_value
1027: BULK COLLECT INTO l_attr_grp_tbl, l_attr_name_tbl, l_mod_value_tbl