APPS.QP_DELAYED_REQUESTS_UTIL dependencies on QP_LIST_HEADER_PHASES

Line 89: delete from qp_list_header_phases

85: ) IS
86:
87: BEGIN
88:
89: delete from qp_list_header_phases
90: where list_header_id = p_List_Header_ID;
91:
92: /*
93: Bug - 8224336

Line 95: Column PRIC_PROD_ATTR_ONLY_FLAG in table qp_list_header_phases will be -

91:
92: /*
93: Bug - 8224336
94: Changes for Pattern Engine - added column PRIC_PROD_ATTR_ONLY_FLAG
95: Column PRIC_PROD_ATTR_ONLY_FLAG in table qp_list_header_phases will be -
96: 'Y' - If all the lines in the header for that phase have only product or pricing or both attributes (but not qualifiers).
97: 'N' - If atleast one line within that header or header itself has qualifiers attached, for that phase
98: */
99:

Line 100: insert into qp_list_header_phases

96: 'Y' - If all the lines in the header for that phase have only product or pricing or both attributes (but not qualifiers).
97: 'N' - If atleast one line within that header or header itself has qualifiers attached, for that phase
98: */
99:
100: insert into qp_list_header_phases
101: (list_header_id, pricing_phase_id,PRIC_PROD_ATTR_ONLY_FLAG)
102: (
103: select distinct list_header_id , pricing_phase_id,'N'
104: from qp_list_lines