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 2772: l_msg_rec.TABLE_NAME :='QP_INTERFACE_QUALIFIERS';

2768: --Initially setting the message context.
2769:
2770: l_msg_rec.REQUEST_ID := P_QUALIFIER_REC.REQUEST_ID(I);
2771: l_msg_rec.ENTITY_TYPE :='PRL';
2772: l_msg_rec.TABLE_NAME :='QP_INTERFACE_QUALIFIERS';
2773: l_msg_rec.ORIG_SYS_HEADER_REF := p_qualifier_rec.orig_sys_header_ref(I);
2774: l_msg_rec.ORIG_SYS_QUALIFIER_REF := p_qualifier_rec.orig_sys_qualifier_ref(I);
2775: l_msg_rec.ORIG_SYS_QUALIFIER_REF := NULL;
2776: l_msg_rec.ORIG_SYS_PRICING_ATTR_REF := NULL;

Line 3113: from qp_interface_qualifiers

3109: END IF;
3110: If p_qualifier_rec.interface_action_code(I)='INSERT' THEN
3111: l_exist:=null;
3112: Select count(*) INTO l_exist
3113: from qp_interface_qualifiers
3114: where request_id = p_qualifier_rec.request_id(I)
3115: and orig_sys_qualifier_ref=p_qualifier_rec.orig_sys_qualifier_ref(I)
3116: and p_qualifier_rec.process_status_flag(I) ='P' --is null
3117: and orig_sys_header_ref = p_qualifier_rec.orig_sys_header_ref(I);

Line 3204: from qp_interface_qualifiers

3200: if l_exist = 0 then
3201: qp_bulk_loader_pub.write_log( 'Secondary Price List dupl. checkin int. table');
3202: begin
3203: select 1 into l_exist
3204: from qp_interface_qualifiers
3205: where request_id = p_qualifier_rec.request_id(I)
3206: and orig_sys_header_ref = p_qualifier_rec.orig_sys_header_ref(I)
3207: and orig_sys_qualifier_ref <> p_qualifier_rec.orig_sys_qualifier_ref(I)
3208: and qualifier_context = 'MODLIST'

Line 3257: FROM QP_INTERFACE_QUALIFIERS

3253: END IF;
3254: l_exist:=0;
3255: SELECT count(*)
3256: INTO l_exist
3257: FROM QP_INTERFACE_QUALIFIERS
3258: WHERE QUALIFIER_CONTEXT = 'MODLIST'
3259: AND QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE4'
3260: AND request_id = p_qualifier_rec.request_id(I)
3261: AND (QUALIFIER_ATTR_VALUE = p_qualifier_rec.qualifier_attr_value(I)

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

5770: orig_sys_pricing_attr_ref, error_message)
5771: SELECT
5772: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5773: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5774: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'COMPARISON_OPERATOR',
5775: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5776: FROM QP_INTERFACE_QUALIFIERS qpiq
5777: WHERE qpiq.request_id = p_request_id
5778: AND qpiq.process_status_flag ='P' --is null

Line 5776: FROM QP_INTERFACE_QUALIFIERS qpiq

5772: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5773: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5774: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'COMPARISON_OPERATOR',
5775: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5776: FROM QP_INTERFACE_QUALIFIERS qpiq
5777: WHERE qpiq.request_id = p_request_id
5778: AND qpiq.process_status_flag ='P' --is null
5779: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5780: AND qpiq.comparison_operator_code is NOT NULL

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

5797: orig_sys_pricing_attr_ref,error_message)
5798: SELECT
5799: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5800: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5801: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'ORIG_SYS_HEADER_REF',
5802: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5803: FROM QP_INTERFACE_QUALIFIERS qpiq
5804: WHERE qpiq.request_id = p_request_id
5805: AND qpiq.process_status_flag ='P' --is null

Line 5803: FROM QP_INTERFACE_QUALIFIERS qpiq

5799: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5800: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5801: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'ORIG_SYS_HEADER_REF',
5802: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5803: FROM QP_INTERFACE_QUALIFIERS qpiq
5804: WHERE qpiq.request_id = p_request_id
5805: AND qpiq.process_status_flag ='P' --is null
5806: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5807: AND qpiq.orig_sys_header_ref is NOT NULL

Line 5833: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',

5829: orig_sys_pricing_attr_ref, error_message)
5830: SELECT
5831: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5832: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5833: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5834: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5835: FROM QP_INTERFACE_QUALIFIERS qpiq
5836: WHERE qpiq.request_id = p_request_id
5837: AND qpiq.process_status_flag ='P' --is null

Line 5835: FROM QP_INTERFACE_QUALIFIERS qpiq

5831: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5832: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5833: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5834: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5835: FROM QP_INTERFACE_QUALIFIERS qpiq
5836: WHERE qpiq.request_id = p_request_id
5837: AND qpiq.process_status_flag ='P' --is null
5838: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5839: AND (qpiq.qualifier_context <> 'MODLIST'

Line 5859: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',

5855: orig_sys_pricing_attr_ref, error_message)
5856: SELECT
5857: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5858: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5859: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5860: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5861: FROM QP_INTERFACE_QUALIFIERS qpiq
5862: WHERE qpiq.request_id = p_request_id
5863: AND qpiq.process_status_flag ='P' --is null

Line 5861: FROM QP_INTERFACE_QUALIFIERS qpiq

5857: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5858: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5859: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS',
5860: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null, l_msg_txt
5861: FROM QP_INTERFACE_QUALIFIERS qpiq
5862: WHERE qpiq.request_id = p_request_id
5863: AND qpiq.process_status_flag ='P' --is null
5864: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5865: AND qpiq.qualifier_context IS NULL;

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

5880: orig_sys_pricing_attr_ref,error_message)
5881: SELECT
5882: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5883: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5884: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5885: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5886: FROM QP_INTERFACE_QUALIFIERS qpiq
5887: WHERE qpiq.request_id = p_request_id
5888: AND qpiq.process_status_flag ='P' --is null

Line 5886: FROM QP_INTERFACE_QUALIFIERS qpiq

5882: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5883: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5884: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5885: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5886: FROM QP_INTERFACE_QUALIFIERS qpiq
5887: WHERE qpiq.request_id = p_request_id
5888: AND qpiq.process_status_flag ='P' --is null
5889: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5890: AND qpiq.qualifier_attribute is not null

Line 5895: FROM qp_interface_qualifiers b,

5891: AND qpiq.qualifier_attribute_code is not null
5892: AND qpiq.qualifier_attribute_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5893: AND NOT EXISTS (
5894: SELECT 'x'
5895: FROM qp_interface_qualifiers b,
5896: qp_prc_contexts_b d,
5897: qp_segments_b e,
5898: qp_pte_segments f
5899: WHERE b.qualifier_context = d.prc_context_code

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

5914: orig_sys_pricing_attr_ref,error_message)
5915: SELECT
5916: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5917: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5918: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5919: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5920: FROM QP_INTERFACE_QUALIFIERS qpiq
5921: WHERE qpiq.request_id = p_request_id
5922: AND qpiq.process_status_flag ='P' --is null

Line 5920: FROM QP_INTERFACE_QUALIFIERS qpiq

5916: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5917: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5918: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5919: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5920: FROM QP_INTERFACE_QUALIFIERS qpiq
5921: WHERE qpiq.request_id = p_request_id
5922: AND qpiq.process_status_flag ='P' --is null
5923: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5924: AND qpiq.qualifier_attribute is null

Line 5929: FROM qp_interface_qualifiers b,

5925: AND qpiq.qualifier_attribute_code is not null
5926: AND qpiq.qualifier_attribute_code <> QP_BULK_LOADER_PUB.G_NULL_CHAR
5927: AND NOT EXISTS (
5928: SELECT 'x'
5929: FROM qp_interface_qualifiers b,
5930: qp_prc_contexts_b d,
5931: qp_segments_b e,
5932: qp_pte_segments f
5933: WHERE b.qualifier_context = d.prc_context_code

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

5947: orig_sys_pricing_attr_ref,error_message)
5948: SELECT
5949: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5950: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5951: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5952: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5953: FROM QP_INTERFACE_QUALIFIERS qpiq
5954: WHERE qpiq.request_id = p_request_id
5955: AND qpiq.process_status_flag ='P' --is null

Line 5953: FROM QP_INTERFACE_QUALIFIERS qpiq

5949: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5950: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,
5951: NULL,NULL, 'PRL', 'QP_INTERFACE_QUALIFIERS', 'QUALIFIER_ATTRIBUTE',
5952: qpiq.orig_sys_header_ref,null,qpiq.orig_sys_qualifier_ref,null,l_msg_txt
5953: FROM QP_INTERFACE_QUALIFIERS qpiq
5954: WHERE qpiq.request_id = p_request_id
5955: AND qpiq.process_status_flag ='P' --is null
5956: AND qpiq.interface_action_code IN ('INSERT', 'UPDATE')
5957: AND qpiq.qualifier_attribute is not null

Line 5961: FROM qp_interface_qualifiers b,

5957: AND qpiq.qualifier_attribute is not null
5958: AND qpiq.qualifier_attribute_code is null
5959: AND NOT EXISTS (
5960: SELECT 'x'
5961: FROM qp_interface_qualifiers b,
5962: qp_prc_contexts_b d,
5963: qp_segments_b e,
5964: qp_pte_segments f
5965: WHERE b.qualifier_context = d.prc_context_code

Line 6732: UPDATE qp_interface_qualifiers q

6728: AND e.request_id = p_request_id );
6729:
6730: ELSIF p_table_type = 'QUALIFIER' THEN
6731:
6732: UPDATE qp_interface_qualifiers q
6733: SET process_status_flag = NULL --'E'
6734: WHERE q.request_id =p_request_id
6735: AND EXISTS
6736: (SELECT orig_sys_qualifier_ref

Line 6740: AND e.table_name ='QP_INTERFACE_QUALIFIERS'

6736: (SELECT orig_sys_qualifier_ref
6737: FROM qp_interface_errors e
6738: WHERE e.orig_sys_qualifier_ref = q.orig_sys_qualifier_ref
6739: AND e.orig_sys_header_ref = q.orig_sys_header_ref
6740: AND e.table_name ='QP_INTERFACE_QUALIFIERS'
6741: AND e.request_id = p_request_id);
6742:
6743: ELSIF p_table_type = 'LINE' THEN
6744: