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_VALIDATE dependencies on QP_INTERFACE_QUALIFIERS

Line 2644: l_msg_rec.TABLE_NAME :='QP_INTERFACE_QUALIFIERS';

2640: --Initially setting the message context.
2641:
2642: l_msg_rec.REQUEST_ID := P_QUALIFIER_REC.REQUEST_ID(I);
2643: l_msg_rec.ENTITY_TYPE :='PRL';
2644: l_msg_rec.TABLE_NAME :='QP_INTERFACE_QUALIFIERS';
2645: l_msg_rec.ORIG_SYS_HEADER_REF := p_qualifier_rec.orig_sys_header_ref(I);
2646: l_msg_rec.ORIG_SYS_QUALIFIER_REF := p_qualifier_rec.orig_sys_qualifier_ref(I);
2647: l_msg_rec.ORIG_SYS_QUALIFIER_REF := NULL;
2648: l_msg_rec.ORIG_SYS_PRICING_ATTR_REF := NULL;

Line 2984: Select /+ index(qp_interface_qualifiers QP_INTERFACE_QUALIFIERS_N3) / --bug8359604

2980: QP_BULK_MSG.add(l_msg_rec);
2981: END IF;
2982: If p_qualifier_rec.interface_action_code(I)='INSERT' THEN
2983: l_exist:=null;
2984: Select /*+ index(qp_interface_qualifiers QP_INTERFACE_QUALIFIERS_N3) */ --bug8359604
2985: count(*) INTO l_exist
2986: from qp_interface_qualifiers
2987: where request_id = p_qualifier_rec.request_id(I)
2988: and orig_sys_qualifier_ref=p_qualifier_rec.orig_sys_qualifier_ref(I)

Line 2986: from qp_interface_qualifiers

2982: If p_qualifier_rec.interface_action_code(I)='INSERT' THEN
2983: l_exist:=null;
2984: Select /*+ index(qp_interface_qualifiers QP_INTERFACE_QUALIFIERS_N3) */ --bug8359604
2985: count(*) INTO l_exist
2986: from qp_interface_qualifiers
2987: where request_id = p_qualifier_rec.request_id(I)
2988: and orig_sys_qualifier_ref=p_qualifier_rec.orig_sys_qualifier_ref(I)
2989: and p_qualifier_rec.process_status_flag(I) ='P' --is null
2990: and orig_sys_header_ref = p_qualifier_rec.orig_sys_header_ref(I);

Line 3077: from qp_interface_qualifiers

3073: if l_exist = 0 then
3074: qp_bulk_loader_pub.write_log( 'Secondary Price List dupl. checkin int. table');
3075: begin
3076: select 1 into l_exist
3077: from qp_interface_qualifiers
3078: where request_id = p_qualifier_rec.request_id(I)
3079: and orig_sys_header_ref = p_qualifier_rec.orig_sys_header_ref(I)
3080: and orig_sys_qualifier_ref <> p_qualifier_rec.orig_sys_qualifier_ref(I)
3081: and qualifier_context = 'MODLIST'

Line 3130: FROM QP_INTERFACE_QUALIFIERS

3126: END IF;
3127: l_exist:=0;
3128: SELECT count(*)
3129: INTO l_exist
3130: FROM QP_INTERFACE_QUALIFIERS
3131: WHERE QUALIFIER_CONTEXT = 'MODLIST'
3132: AND QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE4'
3133: AND request_id = p_qualifier_rec.request_id(I)
3134: AND (QUALIFIER_ATTR_VALUE = p_qualifier_rec.qualifier_attr_value(I)

Line 5762: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'COMPARISON_OPERATOR',

5758: orig_sys_pricing_attr_ref, error_message)
5759: SELECT
5760: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5761: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5762: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'COMPARISON_OPERATOR',
5763: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5764: FROM QP_INTERFACE_QUALIFIERS qpiq
5765: WHERE qpiq.request_id = p_request_id
5766: AND qpiq.process_status_flag ='P' --is null

Line 5764: FROM QP_INTERFACE_QUALIFIERS qpiq

5760: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5761: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5762: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'COMPARISON_OPERATOR',
5763: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5764: FROM QP_INTERFACE_QUALIFIERS qpiq
5765: WHERE qpiq.request_id = p_request_id
5766: AND qpiq.process_status_flag ='P' --is null
5767: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5768: AND qpiq.comparison_operator_code is NOT NULL

Line 5789: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'ORIG_SYS_HEADER_REF',

5785: orig_sys_pricing_attr_ref,error_message)
5786: SELECT
5787: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5788: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5789: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'ORIG_SYS_HEADER_REF',
5790: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5791: FROM QP_INTERFACE_QUALIFIERS qpiq
5792: WHERE qpiq.request_id = p_request_id
5793: AND qpiq.process_status_flag ='P' --is null

Line 5791: FROM QP_INTERFACE_QUALIFIERS qpiq

5787: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5788: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5789: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'ORIG_SYS_HEADER_REF',
5790: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5791: FROM QP_INTERFACE_QUALIFIERS qpiq
5792: WHERE qpiq.request_id = p_request_id
5793: AND qpiq.process_status_flag ='P' --is null
5794: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5795: AND qpiq.orig_sys_header_ref is NOT NULL

Line 5821: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',

5817: orig_sys_pricing_attr_ref, error_message)
5818: SELECT
5819: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5820: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5821: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5822: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5823: FROM QP_INTERFACE_QUALIFIERS qpiq
5824: WHERE qpiq.request_id = p_request_id
5825: AND qpiq.process_status_flag ='P' --is null

Line 5823: FROM QP_INTERFACE_QUALIFIERS qpiq

5819: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5820: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5821: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5822: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5823: FROM QP_INTERFACE_QUALIFIERS qpiq
5824: WHERE qpiq.request_id = p_request_id
5825: AND qpiq.process_status_flag ='P' --is null
5826: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5827: AND (qpiq.qualifier_context <> 'MODLIST'

Line 5847: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',

5843: orig_sys_pricing_attr_ref, error_message)
5844: SELECT
5845: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5846: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5847: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5848: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5849: FROM QP_INTERFACE_QUALIFIERS qpiq
5850: WHERE qpiq.request_id = p_request_id
5851: AND qpiq.process_status_flag ='P' --is null

Line 5849: FROM QP_INTERFACE_QUALIFIERS qpiq

5845: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5846: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5847: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5848: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5849: FROM QP_INTERFACE_QUALIFIERS qpiq
5850: WHERE qpiq.request_id = p_request_id
5851: AND qpiq.process_status_flag ='P' --is null
5852: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5853: AND qpiq.qualifier_context IS NULL;

Line 5872: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',

5868: orig_sys_pricing_attr_ref,error_message)
5869: SELECT
5870: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5871: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5872: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5873: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5874: FROM QP_INTERFACE_QUALIFIERS qpiq
5875: WHERE qpiq.request_id = p_request_id
5876: AND qpiq.process_status_flag ='P' --is null

Line 5874: FROM QP_INTERFACE_QUALIFIERS qpiq

5870: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5871: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5872: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5873: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5874: FROM QP_INTERFACE_QUALIFIERS qpiq
5875: WHERE qpiq.request_id = p_request_id
5876: AND qpiq.process_status_flag ='P' --is null
5877: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5878: AND qpiq.qualifier_attribute is not null

Line 5883: FROM qp_interface_qualifiers b,

5879: AND qpiq.qualifier_attribute_code is not null
5880: AND qpiq.qualifier_attribute_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5881: AND NOT EXISTS (
5882: SELECT 'x'
5883: FROM qp_interface_qualifiers b,
5884: qp_prc_contexts_b d,
5885: qp_segments_b e,
5886: qp_pte_segments f
5887: WHERE b.qualifier_context = d.prc_context_code

Line 5906: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',

5902: orig_sys_pricing_attr_ref,error_message)
5903: SELECT
5904: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5905: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5906: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5907: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5908: FROM QP_INTERFACE_QUALIFIERS qpiq
5909: WHERE qpiq.request_id = p_request_id
5910: AND qpiq.process_status_flag ='P' --is null

Line 5908: FROM QP_INTERFACE_QUALIFIERS qpiq

5904: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5905: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5906: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5907: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5908: FROM QP_INTERFACE_QUALIFIERS qpiq
5909: WHERE qpiq.request_id = p_request_id
5910: AND qpiq.process_status_flag ='P' --is null
5911: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5912: AND qpiq.qualifier_attribute is null

Line 5917: FROM qp_interface_qualifiers b,

5913: AND qpiq.qualifier_attribute_code is not null
5914: AND qpiq.qualifier_attribute_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5915: AND NOT EXISTS (
5916: SELECT 'x'
5917: FROM qp_interface_qualifiers b,
5918: qp_prc_contexts_b d,
5919: qp_segments_b e,
5920: qp_pte_segments f
5921: WHERE b.qualifier_context = d.prc_context_code

Line 5939: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',

5935: orig_sys_pricing_attr_ref,error_message)
5936: SELECT
5937: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5938: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5939: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5940: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5941: FROM QP_INTERFACE_QUALIFIERS qpiq
5942: WHERE qpiq.request_id = p_request_id
5943: AND qpiq.process_status_flag ='P' --is null

Line 5941: FROM QP_INTERFACE_QUALIFIERS qpiq

5937: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5938: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5939: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5940: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5941: FROM QP_INTERFACE_QUALIFIERS qpiq
5942: WHERE qpiq.request_id = p_request_id
5943: AND qpiq.process_status_flag ='P' --is null
5944: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5945: AND qpiq.qualifier_attribute is not null

Line 5949: FROM qp_interface_qualifiers b,

5945: AND qpiq.qualifier_attribute is not null
5946: AND qpiq.qualifier_attribute_code is null
5947: AND NOT EXISTS (
5948: SELECT 'x'
5949: FROM qp_interface_qualifiers b,
5950: qp_prc_contexts_b d,
5951: qp_segments_b e,
5952: qp_pte_segments f
5953: WHERE b.qualifier_context = d.prc_context_code

Line 6720: UPDATE qp_interface_qualifiers q

6716: AND e.request_id = p_request_id );
6717:
6718: ELSIF p_table_type = 'QUALIFIER' THEN
6719:
6720: UPDATE qp_interface_qualifiers q
6721: SET process_status_flag = NULL --'E'
6722: WHERE q.request_id =p_request_id
6723: AND EXISTS
6724: (SELECT orig_sys_qualifier_ref

Line 6728: AND e.table_name ='QP_INTERFACE_QUALIFIERS'

6724: (SELECT orig_sys_qualifier_ref
6725: FROM qp_interface_errors e
6726: WHERE e.orig_sys_qualifier_ref = q.orig_sys_qualifier_ref
6727: AND e.orig_sys_header_ref = q.orig_sys_header_ref
6728: AND e.table_name ='QP_INTERFACE_QUALIFIERS'
6729: AND e.request_id = p_request_id);
6730:
6731: ELSIF p_table_type = 'LINE' THEN
6732: