eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_BULK_LOADER_PUB dependencies on QP_LIST_HEADERS

Line 167: from qp_list_headers_b

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);

Line 188: from qp_segments_b a, qp_prc_contexts_b b, qp_qualifiers c, qp_list_headers_b h

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

Line 202: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h

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

Line 216: from qp_segments_b a, qp_prc_contexts_b b, qp_pricing_attributes c, qp_list_headers_b h

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

Line 317: select 1 from qp_list_headers_b qplh

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');

Line 346: select 1 from qp_list_headers qplh

342: AND qpih.interface_action_code IN ('INSERT','UPDATE','DELETE')
343: -- Bug 5208480(5208112,4188784) RAVI
344: -- Should not be able to update list type code
345: AND NOT EXISTS(
346: select 1 from qp_list_headers qplh
347: where qpih.interface_action_code = 'UPDATE'
348: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
349: and qplh.list_type_code <> qpih.list_type_code
350: )

Line 353: select 1 from qp_list_headers qplh

349: and qplh.list_type_code <> qpih.list_type_code
350: )
351: -- Should not be able to update list header id
352: AND NOT EXISTS(
353: select 1 from qp_list_headers qplh
354: where qpih.interface_action_code = 'UPDATE'
355: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
356: and qpih.list_header_id is not null
357: and qplh.list_header_id <> qpih.list_header_id

Line 364: select 1 from qp_list_headers qplh

360: --Bug#5208112 RAVI
361: --Validation shifted to QP_BULK_VALIDATE package.
362: /**
363: AND NOT EXISTS(
364: select 1 from qp_list_headers qplh
365: where qpih.interface_action_code = 'UPDATE'
366: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
367: and qpih.rounding_factor is not null
368: and qplh.rounding_factor <> qpih.rounding_factor

Line 374: select 1 from qp_list_headers qplh

370: **/
371: -- Bug# 5246745 RAVI
372: -- Should not be able to update list source code
373: AND NOT EXISTS(
374: select 1 from qp_list_headers qplh
375: where qpih.interface_action_code = 'UPDATE'
376: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
377: and qpih.list_source_code is not null
378: and qplh.list_source_code <> qpih.list_source_code

Line 383: select 1 from qp_list_headers qplh

379: )
380: -- Bug# 5246745 RAVI
381: -- Should not be able to update list source code
382: AND NOT EXISTS(
383: select 1 from qp_list_headers qplh
384: where qpih.interface_action_code = 'UPDATE'
385: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
386: and qpih.source_system_code is not null
387: and qplh.source_system_code <> qpih.source_system_code

Line 392: select 1 from qp_list_headers qplh

388: )
389: -- Bug# 5246745 RAVI
390: -- Should not be able to update list source code
391: AND NOT EXISTS(
392: select 1 from qp_list_headers qplh
393: where qpih.interface_action_code = 'UPDATE'
394: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
395: and qpih.source_system_code is not null
396: and qplh.source_system_code <> qpih.source_system_code

Line 399: select 1 from qp_list_headers qplh

395: and qpih.source_system_code is not null
396: and qplh.source_system_code <> qpih.source_system_code
397: )
398: AND NOT EXISTS(
399: select 1 from qp_list_headers qplh
400: where qpih.interface_action_code = 'INSERT'
401: -- ENH undo alcoa changes RAVI
402: /**
403: The key between interface and qp tables is only orig_sys_hdr_ref

Line 908: from qp_list_headers qplh

904: null,
905: qpih.global_flag
906: )
907: )
908: from qp_list_headers qplh
909: where qplh.orig_system_header_ref=qpih.orig_sys_header_ref
910: )
911: where qpih.request_id = l_request_id
912: and qpih.process_status_flag = 'P'

Line 940: select 1 from qp_list_headers_b qplh

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');

Line 969: select 1 from qp_list_headers qplh

965: AND nvl(qpih.process_type,' ') = nvl(p_process_type, nvl(qpih.process_type,' '))
966: AND qpih.interface_action_code IN ('INSERT','UPDATE','DELETE')
967: -- Bug 5208480(5208112,4188784) RAVI
968: AND NOT EXISTS(
969: select 1 from qp_list_headers qplh
970: where qpih.interface_action_code = 'UPDATE'
971: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
972: and qplh.list_type_code <> qpih.list_type_code
973: )

Line 975: select 1 from qp_list_headers qplh

971: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
972: and qplh.list_type_code <> qpih.list_type_code
973: )
974: AND NOT EXISTS(
975: select 1 from qp_list_headers qplh
976: where qpih.interface_action_code = 'UPDATE'
977: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
978: and qpih.list_header_id is not null
979: and qplh.list_header_id <> qpih.list_header_id

Line 982: select 1 from qp_list_headers qplh

978: and qpih.list_header_id is not null
979: and qplh.list_header_id <> qpih.list_header_id
980: )
981: AND NOT EXISTS(
982: select 1 from qp_list_headers qplh
983: where qpih.interface_action_code = 'UPDATE'
984: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
985: and qpih.rounding_factor is not null
986: and qplh.rounding_factor <> qpih.rounding_factor

Line 991: select 1 from qp_list_headers qplh

987: )
988: -- Bug# 5246745 RAVI
989: -- Should not be able to update list source code
990: AND NOT EXISTS(
991: select 1 from qp_list_headers qplh
992: where qpih.interface_action_code = 'UPDATE'
993: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
994: and qpih.list_source_code is not null
995: and qplh.list_source_code <> qpih.list_source_code

Line 1000: select 1 from qp_list_headers qplh

996: )
997: -- Bug# 5246745 RAVI
998: -- Should not be able to update list source code
999: AND NOT EXISTS(
1000: select 1 from qp_list_headers qplh
1001: where qpih.interface_action_code = 'UPDATE'
1002: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1003: and qpih.source_system_code is not null
1004: and qplh.source_system_code <> qpih.source_system_code

Line 1009: select 1 from qp_list_headers qplh

1005: )
1006: -- Bug# 5246745 RAVI
1007: -- Should not be able to update list source code
1008: AND NOT EXISTS(
1009: select 1 from qp_list_headers qplh
1010: where qpih.interface_action_code = 'UPDATE'
1011: and qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1012: and qpih.source_system_code is not null
1013: and qplh.source_system_code <> qpih.source_system_code

Line 1016: select 1 from qp_list_headers qplh

1012: and qpih.source_system_code is not null
1013: and qplh.source_system_code <> qpih.source_system_code
1014: )
1015: AND NOT EXISTS(
1016: select 1 from qp_list_headers qplh
1017: where qpih.interface_action_code = 'INSERT'
1018: -- ENH undo alcoa changes RAVI
1019: /**
1020: The key between interface and qp tables is only orig_sys_hdr_ref

Line 1525: from qp_list_headers qplh

1521: null,
1522: qpih.global_flag
1523: )
1524: )
1525: from qp_list_headers qplh
1526: where qplh.orig_system_header_ref=qpih.orig_sys_header_ref
1527: )
1528: where qpih.request_id = l_request_id
1529: and qpih.process_status_flag = 'P'

Line 1980: qp_list_headers_b qplh

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

Line 2830: from qp_list_headers qplh,

2826: null,
2827: qpil.substitution_value
2828: )
2829: )
2830: from qp_list_headers qplh,
2831: qp_list_lines qpll
2832: where -- CAUSES FTS AS NO INDEX ON LINE_REF
2833: qpil.orig_sys_line_ref = qpll.orig_sys_line_ref
2834: and qpll.list_header_id = qplh.list_header_id

Line 3288: qp_list_headers_b qplh

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

Line 4207: from qp_list_headers qplh,

4203: null,
4204: qpil.substitution_value
4205: )
4206: )
4207: from qp_list_headers qplh,
4208: qp_list_lines qpll
4209: where -- CAUSES FTS AS NO INDEX ON LINE_REF
4210: qpil.orig_sys_line_ref = qpll.orig_sys_line_ref
4211: and qpll.list_header_id = qplh.list_header_id

Line 4536: qp_list_headers_b qplh

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

Line 6649: Delete from qp_list_headers_tl

6645: IS
6646: BEGIN
6647: write_log('Entering POST_CLEANUP');
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

Line 6652: from qp_list_headers_b b, qp_interface_list_headers h

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'

Line 6659: select 1 from qp_list_headers qplh

6655: and h.process_status_flag IS NULL
6656: and h.interface_action_code = 'INSERT'
6657: -- 6028305
6658: AND NOT EXISTS(
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

Line 6663: Delete from qp_list_headers_b

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

Line 6672: select 1 from qp_list_headers qplh

6668: and h.process_status_flag IS NULL
6669: and h.interface_action_code = 'INSERT'
6670: -- 6028305
6671: AND NOT EXISTS(
6672: select 1 from qp_list_headers qplh
6673: where h.interface_action_code = 'INSERT'
6674: and qplh.orig_system_header_ref=h.orig_sys_header_ref));
6675:
6676: Delete from qp_qualifiers