[Home] [Help]
163: l_req_data_counter:=to_number(l_req_data) + 1;
164:
165: select min(list_header_id), max(list_header_id)
166: into l_min_hdr_id, l_max_hdr_id
167: from qp_list_headers_b
168: where request_id = l_request_id;
169:
170: write_log( 'LOW HEADER ID: '||l_min_hdr_id);
171: write_log( 'HIGH HEADER ID: '||l_max_hdr_id);
184: set used_in_setup='Y'
185: where nvl(used_in_setup,'N')='N'
186: and segment_id in
187: (select a.segment_id
188: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c, qp_list_headers_b h
189: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
190: and h.active_flag = 'Y'
191: and c.list_header_id = h.list_header_id
192: and a.segment_mapping_column = c.qualifier_attribute
198: set used_in_setup='Y'
199: where nvl(used_in_setup,'N')='N'
200: and segment_id in
201: (select a.segment_id
202: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h
203: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
204: and h.active_flag = 'Y'
205: and c.list_header_id = h.list_header_id
206: and a.segment_mapping_column = c.pricing_attribute
212: set used_in_setup='Y'
213: where nvl(used_in_setup,'N')='N'
214: and segment_id in
215: (select a.segment_id
216: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h
217: where h.list_header_id BETWEEN l_min_hdr_id and l_max_hdr_id
218: and h.active_flag = 'Y'
219: and c.list_header_id = h.list_header_id
220: and a.segment_mapping_column = c.product_attribute
313: WHERE qpih.name = p_entity_name
314: AND qpih.process_status_flag ='P' --is null
315: AND qpih.interface_action_code ='INSERT'
316: AND EXISTS(
317: select 1 from qp_list_headers_b qplh
318: where qplh.orig_system_header_ref=qpih.orig_sys_header_ref
319: );
320: IF SQL%ROWCOUNT > 0 THEN
321: Write_Log('ERROR: Hdr_Ref not Unique');
936: AND nvl(qpih.process_id,0) = nvl(p_process_id, nvl(qpih.process_id,0))
937: AND qpih.process_status_flag ='P' --is null
938: AND qpih.interface_action_code ='INSERT'
939: AND EXISTS(
940: select 1 from qp_list_headers_b qplh
941: where qplh.orig_system_header_ref=qpih.orig_sys_header_ref
942: );
943: IF SQL%ROWCOUNT > 0 THEN
944: Write_Log('ERROR: Hdr_Ref not Unique');
1976: QP_BULK_LOADER_PUB.G_NULL_CHAR, null,
1977: qpiq.qualifier_attr_value_code
1978: )
1979: from qp_qualifiers qphq,
1980: qp_list_headers_b qplh
1981: where -- CAUSES FTS AS NO INDEX ON LINE_REF
1982: qpiq.orig_sys_qualifier_ref = qphq.orig_sys_qualifier_ref
1983: and qphq.list_header_id = qplh.list_header_id
1984: and qplh.orig_system_header_ref=qpiq.orig_sys_header_ref
3284: qpip.pricing_attr_value_to_disp
3285: )
3286: --Bug# 5456164 RAVI END
3287: from qp_pricing_attributes qppa,
3288: qp_list_headers_b qplh
3289: where -- CAUSES FTS AS NO INDEX ON PRICNG_ATTR_REF
3290: qpip.orig_sys_pricing_attr_ref = qppa.orig_sys_pricing_attr_ref
3291: and qppa.list_header_id = qplh.list_header_id
3292: and qplh.orig_system_header_ref=qpip.orig_sys_header_ref
4532: null,qpip.qualification_ind
4533: )
4534: )
4535: from qp_pricing_attributes qppa,
4536: qp_list_headers_b qplh
4537: where -- CAUSES FTS AS NO INDEX ON PRICNG_ATTR_REF
4538: qpip.orig_sys_pricing_attr_ref = qppa.orig_sys_pricing_attr_ref
4539: and qppa.list_header_id = qplh.list_header_id
4540: and qplh.orig_system_header_ref=qpip.orig_sys_header_ref
6648:
6649: Delete from qp_list_headers_tl
6650: where list_header_id IN
6651: (Select b.list_header_id
6652: from qp_list_headers_b b, qp_interface_list_headers h
6653: where h.request_id = p_request_id
6654: and b.orig_system_header_ref=h.orig_sys_header_ref
6655: and h.process_status_flag IS NULL
6656: and h.interface_action_code = 'INSERT'
6659: select 1 from qp_list_headers qplh
6660: where h.interface_action_code = 'INSERT'
6661: and qplh.orig_system_header_ref=h.orig_sys_header_ref));
6662:
6663: Delete from qp_list_headers_b
6664: where orig_system_header_ref IN
6665: (Select orig_sys_header_ref
6666: from qp_interface_list_headers h
6667: where h.request_id = p_request_id