APPS.PO_AUTOCREATE_PVT dependencies on PO_LINES_EXT_DRAFT_DIFF_V

Line 735: ELSIF p_mod_doc_source_name = 'PO_LINES_EXT_DRAFT_DIFF_V' THEN

731: l_attr_group_type := 'PO_HEADER_EXT_ATTRS';
732: l_data_level := 'PO_HEADER';
733:
734:
735: ELSIF p_mod_doc_source_name = 'PO_LINES_EXT_DRAFT_DIFF_V' THEN
736: l_attr_group_type := 'PO_LINE_EXT_ATTRS';
737: l_data_level := 'PO_LINE';
738:
739:

Line 959: ELSIF p_mod_doc_source_name ='PO_LINES_EXT_DRAFT_DIFF_V' THEN

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 ;
958:
959: ELSIF p_mod_doc_source_name ='PO_LINES_EXT_DRAFT_DIFF_V' THEN
960:
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

Line 1044: ELSIF p_mod_doc_source_name ='PO_LINES_EXT_DRAFT_DIFF_V' THEN

1040: AND ATTR_GROUP_NAME = ag_data.attr_grp_name
1041: AND ATTR_NAME = ag_data.attr_name);
1042: --
1043:
1044: ELSIF p_mod_doc_source_name ='PO_LINES_EXT_DRAFT_DIFF_V' THEN
1045: --
1046: --Collecting data for all such attributes that need to be copied from PAR
1047: WITH ag_data AS (
1048: SELECT SubStr(col_name, 1,InStr(col_name,'_'||Chr(0))-1) attr_grp_name,

Line 1051: FROM po_lines_ext_draft_diff_v

1047: WITH ag_data AS (
1048: SELECT SubStr(col_name, 1,InStr(col_name,'_'||Chr(0))-1) attr_grp_name,
1049: SubStr(col_name, InStr(col_name, Chr(0))+1) attr_name ,
1050: col_value col_value
1051: FROM po_lines_ext_draft_diff_v
1052: WHERE col_value IS NOT NULL
1053: ) --Collecting the attribute grp name, aatribute name and their value in ag_data
1054: SELECT ag_data.attr_grp_name, ag_data.attr_name, ag_data.col_value
1055: BULK COLLECT INTO l_attr_grp_tbl, l_attr_name_tbl, l_mod_value_tbl