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 FND_GLOBAL

Line 134: VALUES(l_error_id, SYSDATE, FND_GLOBAL.USER_ID,

130: creation_date, created_by, last_update_login, request_id,
131: program_application_id, program_id, program_update_date, entity_type,
132: table_name, column_name, orig_sys_header_ref, orig_sys_line_ref,
133: orig_sys_qualifier_ref, orig_sys_pricing_attr_ref, error_message)
134: VALUES(l_error_id, SYSDATE, FND_GLOBAL.USER_ID,
135: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id,
136: 661, NULL, NULL, 'PRL',
137: 'QP_INTERFACE_LIST_LINES', NULL, p_orig_sys_header_ref, p_orig_sys_line_ref,
138: NULL, NULL, l_msg);

Line 135: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id,

131: program_application_id, program_id, program_update_date, entity_type,
132: table_name, column_name, orig_sys_header_ref, orig_sys_line_ref,
133: orig_sys_qualifier_ref, orig_sys_pricing_attr_ref, error_message)
134: VALUES(l_error_id, SYSDATE, FND_GLOBAL.USER_ID,
135: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id,
136: 661, NULL, NULL, 'PRL',
137: 'QP_INTERFACE_LIST_LINES', NULL, p_orig_sys_header_ref, p_orig_sys_line_ref,
138: NULL, NULL, l_msg);
139:

Line 3650: IF fnd_global.resp_appl_id=178 OR fnd_global.resp_appl_id=201

3646: IF p_pricing_attr_rec.product_attribute_context(I)='ITEM' AND
3647: p_pricing_attr_rec.product_attribute(I)= 'PRICING_ATTRIBUTE1'
3648: THEN
3649: l_pa_count :=0;
3650: IF fnd_global.resp_appl_id=178 OR fnd_global.resp_appl_id=201
3651: THEN --Check if item is purchasing enabled
3652: Begin
3653: select count(*) into l_pa_count
3654: from qp_interface_pricing_attribs qipa, mtl_system_items msi

Line 4386: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4382: program_id, program_update_date, entity_type, table_name, column_name,
4383: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4384: orig_sys_pricing_attr_ref, error_message)
4385: VALUES
4386: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4387: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4388: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4389: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4390: null,l_msg_txt);

Line 4387: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,

4383: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4384: orig_sys_pricing_attr_ref, error_message)
4385: VALUES
4386: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4387: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4388: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4389: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4390: null,l_msg_txt);
4391:

Line 4452: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4448: program_id, program_update_date, entity_type, table_name, column_name,
4449: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4450: orig_sys_pricing_attr_ref, error_message)
4451: VALUES
4452: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4453: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4454: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4455: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4456: null,l_msg_txt);

Line 4453: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,

4449: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4450: orig_sys_pricing_attr_ref, error_message)
4451: VALUES
4452: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4453: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4454: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4455: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4456: null,l_msg_txt);
4457:

Line 4573: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4569: program_id, program_update_date, entity_type, table_name, column_name,
4570: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4571: orig_sys_pricing_attr_ref, error_message)
4572: VALUES
4573: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4574: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4575: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4576: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4577: null,l_msg_txt);

Line 4574: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,

4570: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4571: orig_sys_pricing_attr_ref, error_message)
4572: VALUES
4573: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4574: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4575: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4576: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4577: null,l_msg_txt);
4578:

Line 4708: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4704: program_id, program_update_date, entity_type, table_name, column_name,
4705: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4706: orig_sys_pricing_attr_ref, error_message)
4707: VALUES
4708: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4709: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4710: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4711: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4712: null,l_msg_txt);

Line 4709: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,

4705: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4706: orig_sys_pricing_attr_ref, error_message)
4707: VALUES
4708: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4709: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4710: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4711: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4712: null,l_msg_txt);
4713: END IF;

Line 4735: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4731: program_id, program_update_date, entity_type, table_name, column_name,
4732: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4733: orig_sys_pricing_attr_ref, error_message)
4734: VALUES
4735: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4736: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4737: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4738: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4739: null,l_msg_txt);

Line 4736: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,

4732: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4733: orig_sys_pricing_attr_ref, error_message)
4734: VALUES
4735: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4736: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4737: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4738: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4739: null,l_msg_txt);
4740: END IF;

Line 4771: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4767: program_id, program_update_date, entity_type, table_name, column_name,
4768: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4769: orig_sys_pricing_attr_ref, error_message)
4770: VALUES
4771: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4772: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4773: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4774: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4775: null,l_msg_txt);

Line 4772: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,

4768: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4769: orig_sys_pricing_attr_ref, error_message)
4770: VALUES
4771: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4772: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4773: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4774: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4775: null,l_msg_txt);
4776: END IF;

Line 4812: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

4808: program_id, program_update_date, entity_type, table_name, column_name,
4809: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4810: orig_sys_pricing_attr_ref, error_message)
4811: VALUES
4812: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4813: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4814: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4815: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4816: null,l_msg_txt);

Line 4813: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,

4809: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4810: orig_sys_pricing_attr_ref, error_message)
4811: VALUES
4812: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4813: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4814: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4815: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4816: null,l_msg_txt);
4817:

Line 5107: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5103: program_id, program_update_date, entity_type, table_name, column_name,
5104: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5105: orig_sys_pricing_attr_ref, error_message)
5106: SELECT
5107: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5108: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5109: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_CODE',
5110: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5111: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5108: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5104: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5105: orig_sys_pricing_attr_ref, error_message)
5106: SELECT
5107: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5108: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5109: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_CODE',
5110: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5111: FROM QP_INTERFACE_LIST_HEADERS qpih
5112: WHERE qpih.request_id = p_request_id

Line 5138: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5134: program_id, program_update_date, entity_type, table_name, column_name,
5135: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5136: orig_sys_pricing_attr_ref, error_message)
5137: SELECT
5138: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5139: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5140: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5141: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5142: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5139: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5135: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5136: orig_sys_pricing_attr_ref, error_message)
5137: SELECT
5138: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5139: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5140: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5141: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5142: FROM QP_INTERFACE_LIST_HEADERS qpih
5143: WHERE qpih.request_id = p_request_id

Line 5163: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5159: program_id, program_update_date, entity_type, table_name, column_name,
5160: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5161: orig_sys_pricing_attr_ref, error_message)
5162: SELECT
5163: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5164: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5165: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5166: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5167: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5164: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5160: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5161: orig_sys_pricing_attr_ref, error_message)
5162: SELECT
5163: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5164: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5165: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5166: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5167: FROM QP_INTERFACE_LIST_HEADERS qpih
5168: WHERE qpih.request_id = p_request_id

Line 5186: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5182: program_id, program_update_date, entity_type, table_name, column_name,
5183: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5184: orig_sys_pricing_attr_ref, error_message)
5185: SELECT
5186: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5187: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5188: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5189: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5190: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5187: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5183: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5184: orig_sys_pricing_attr_ref, error_message)
5185: SELECT
5186: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5187: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5188: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5189: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5190: FROM QP_INTERFACE_LIST_HEADERS qpih
5191: WHERE qpih.request_id = p_request_id

Line 5217: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5213: program_id, program_update_date, entity_type, table_name, column_name,
5214: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5215: orig_sys_pricing_attr_ref, error_message)
5216: SELECT
5217: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5218: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5219: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'LIST_TYPE_CODE',
5220: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5221: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5218: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5214: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5215: orig_sys_pricing_attr_ref, error_message)
5216: SELECT
5217: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5218: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5219: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'LIST_TYPE_CODE',
5220: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5221: FROM QP_INTERFACE_LIST_HEADERS qpih
5222: WHERE qpih.request_id = p_request_id

Line 5246: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5242: program_id, program_update_date, entity_type, table_name, column_name,
5243: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5244: orig_sys_pricing_attr_ref, error_message)
5245: SELECT
5246: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5247: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5248: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5249: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5250: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5247: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5243: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5244: orig_sys_pricing_attr_ref, error_message)
5245: SELECT
5246: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5247: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5248: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5249: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5250: FROM QP_INTERFACE_LIST_HEADERS qpih
5251: WHERE qpih.request_id = p_request_id

Line 5272: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5268: program_id, program_update_date, entity_type, table_name, column_name,
5269: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5270: orig_sys_pricing_attr_ref, error_message)
5271: SELECT
5272: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5273: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5274: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5275: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5276: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5273: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5269: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5270: orig_sys_pricing_attr_ref, error_message)
5271: SELECT
5272: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5273: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5274: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5275: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5276: FROM QP_INTERFACE_LIST_HEADERS qpih
5277: WHERE qpih.request_id = p_request_id

Line 5297: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5293: program_id, program_update_date, entity_type, table_name, column_name,
5294: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5295: orig_sys_pricing_attr_ref, error_message)
5296: SELECT
5297: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5298: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5299: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5300: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5301: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5298: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5294: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5295: orig_sys_pricing_attr_ref, error_message)
5296: SELECT
5297: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5298: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5299: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5300: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5301: FROM QP_INTERFACE_LIST_HEADERS qpih
5302: WHERE qpih.request_id = p_request_id

Line 5329: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5325: program_id, program_update_date, entity_type, table_name, column_name,
5326: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5327: orig_sys_pricing_attr_ref, error_message)
5328: SELECT
5329: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5330: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5331: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5332: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5333: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5330: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5326: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5327: orig_sys_pricing_attr_ref, error_message)
5328: SELECT
5329: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5330: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5331: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5332: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5333: FROM QP_INTERFACE_LIST_HEADERS qpih
5334: WHERE qpih.request_id = p_request_id

Line 5356: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5352: program_id, program_update_date, entity_type, table_name, column_name,
5353: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5354: orig_sys_pricing_attr_ref, error_message)
5355: SELECT
5356: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5357: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5358: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5359: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5360: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5357: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5353: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5354: orig_sys_pricing_attr_ref, error_message)
5355: SELECT
5356: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5357: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5358: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5359: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5360: FROM QP_INTERFACE_LIST_HEADERS qpih
5361: WHERE qpih.request_id = p_request_id

Line 5381: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5377: program_id, program_update_date, entity_type, table_name, column_name,
5378: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5379: orig_sys_pricing_attr_ref, error_message)
5380: SELECT
5381: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5382: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5383: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5384: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5385: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5382: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5378: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5379: orig_sys_pricing_attr_ref, error_message)
5380: SELECT
5381: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5382: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5383: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5384: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5385: FROM QP_INTERFACE_LIST_HEADERS qpih
5386: WHERE qpih.request_id = p_request_id

Line 5419: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5415: program_id, program_update_date, entity_type, table_name, column_name,
5416: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5417: orig_sys_pricing_attr_ref, error_message)
5418: SELECT
5419: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5420: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5421: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5422: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5423: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5420: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5416: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5417: orig_sys_pricing_attr_ref, error_message)
5418: SELECT
5419: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5420: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5421: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5422: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5423: FROM QP_INTERFACE_LIST_HEADERS qpih
5424: WHERE qpih.request_id = p_request_id

Line 5445: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5441: program_id, program_update_date, entity_type, table_name, column_name,
5442: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5443: orig_sys_pricing_attr_ref, error_message)
5444: SELECT
5445: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5446: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5447: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5448: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5449: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5446: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5442: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5443: orig_sys_pricing_attr_ref, error_message)
5444: SELECT
5445: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5446: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5447: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5448: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5449: FROM QP_INTERFACE_LIST_HEADERS qpih
5450: WHERE qpih.request_id = p_request_id

Line 5470: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5466: program_id, program_update_date, entity_type, table_name, column_name,
5467: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5468: orig_sys_pricing_attr_ref, error_message)
5469: SELECT
5470: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5471: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5472: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5473: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5474: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5471: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5467: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5468: orig_sys_pricing_attr_ref, error_message)
5469: SELECT
5470: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5471: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5472: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5473: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5474: FROM QP_INTERFACE_LIST_HEADERS qpih
5475: WHERE qpih.request_id = p_request_id

Line 5499: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5495: program_id, program_update_date, entity_type, table_name, column_name,
5496: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5497: orig_sys_pricing_attr_ref, error_message)
5498: SELECT
5499: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5500: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5501: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5502: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5503: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5500: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5496: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5497: orig_sys_pricing_attr_ref, error_message)
5498: SELECT
5499: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5500: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5501: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5502: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5503: FROM QP_INTERFACE_LIST_HEADERS qpih
5504: WHERE qpih.request_id = p_request_id

Line 5524: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5520: program_id, program_update_date, entity_type, table_name, column_name,
5521: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5522: orig_sys_pricing_attr_ref, error_message)
5523: SELECT
5524: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5525: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5526: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5527: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5528: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5525: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5521: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5522: orig_sys_pricing_attr_ref, error_message)
5523: SELECT
5524: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5525: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5526: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5527: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5528: FROM QP_INTERFACE_LIST_HEADERS qpih
5529: WHERE qpih.request_id = p_request_id

Line 5550: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5546: program_id, program_update_date, entity_type, table_name, column_name,
5547: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5548: orig_sys_pricing_attr_ref, error_message)
5549: SELECT
5550: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5551: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5552: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5553: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5554: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5551: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5547: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5548: orig_sys_pricing_attr_ref, error_message)
5549: SELECT
5550: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5551: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5552: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5553: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5554: FROM QP_INTERFACE_LIST_HEADERS qpih
5555: WHERE qpih.request_id = p_request_id

Line 5579: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5575: program_id, program_update_date, entity_type, table_name, column_name,
5576: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5577: orig_sys_pricing_attr_ref, error_message)
5578: SELECT
5579: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5580: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5581: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'pte_code',
5582: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5583: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5580: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5576: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5577: orig_sys_pricing_attr_ref, error_message)
5578: SELECT
5579: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5580: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5581: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'pte_code',
5582: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5583: FROM QP_INTERFACE_LIST_HEADERS qpih
5584: WHERE qpih.request_id = p_request_id

Line 5606: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5602: program_id, program_update_date, entity_type, table_name, column_name,
5603: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5604: orig_sys_pricing_attr_ref, error_message)
5605: SELECT
5606: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5607: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5608: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5609: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5610: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5607: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5603: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5604: orig_sys_pricing_attr_ref, error_message)
5605: SELECT
5606: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5607: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5608: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5609: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5610: FROM QP_INTERFACE_LIST_HEADERS qpih
5611: WHERE qpih.request_id = p_request_id

Line 5628: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5624: program_id, program_update_date, entity_type, table_name, column_name,
5625: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5626: orig_sys_pricing_attr_ref, error_message)
5627: SELECT
5628: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5629: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5630: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5631: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5632: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5629: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5625: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5626: orig_sys_pricing_attr_ref, error_message)
5627: SELECT
5628: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5629: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5630: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5631: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5632: FROM QP_INTERFACE_LIST_HEADERS qpih
5633: WHERE qpih.request_id = p_request_id

Line 5654: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5650: program_id, program_update_date, entity_type, table_name, column_name,
5651: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5652: orig_sys_pricing_attr_ref, error_message)
5653: SELECT
5654: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5655: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5656: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5657: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5658: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5655: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5651: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5652: orig_sys_pricing_attr_ref, error_message)
5653: SELECT
5654: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5655: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5656: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5657: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5658: FROM QP_INTERFACE_LIST_HEADERS qpih
5659: WHERE qpih.request_id = p_request_id

Line 5678: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5674: program_id, program_update_date, entity_type, table_name, column_name,
5675: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5676: orig_sys_pricing_attr_ref, error_message)
5677: SELECT
5678: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5679: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5680: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ROUNDING_FACTOR',
5681: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5682: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5679: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5675: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5676: orig_sys_pricing_attr_ref, error_message)
5677: SELECT
5678: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5679: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5680: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ROUNDING_FACTOR',
5681: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5682: FROM QP_INTERFACE_LIST_HEADERS qpih
5683: WHERE qpih.request_id = p_request_id

Line 5708: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5704: program_id, program_update_date, entity_type, table_name, column_name,
5705: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5706: orig_sys_pricing_attr_ref, error_message)
5707: SELECT
5708: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5709: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5710: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
5711: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5712: FROM QP_INTERFACE_LIST_HEADERS qpih

Line 5709: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,

5705: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5706: orig_sys_pricing_attr_ref, error_message)
5707: SELECT
5708: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5709: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5710: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
5711: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5712: FROM QP_INTERFACE_LIST_HEADERS qpih
5713: WHERE qpih.request_id = p_request_id

Line 5760: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5756: program_id, program_update_date, entity_type, table_name, column_name,
5757: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5761: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5757: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5787: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5783: program_id, program_update_date, entity_type, table_name, column_name,
5784: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_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

Line 5788: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5784: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_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

Line 5819: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5815: program_id, program_update_date, entity_type, table_name,
5816: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5820: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5816: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5845: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5841: program_id, program_update_date, entity_type, table_name,
5842: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5846: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5842: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5870: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5866: program_id, program_update_date, entity_type, table_name, column_name,
5867: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5871: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5867: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5904: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5900: program_id, program_update_date, entity_type, table_name, column_name,
5901: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5905: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5901: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5937: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

5933: program_id, program_update_date, entity_type, table_name, column_name,
5934: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 5938: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpiq.request_id, 661,

5934: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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

Line 6020: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6016: program_id, program_update_date, entity_type, table_name, column_name,
6017: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6018: orig_sys_pricing_attr_ref,error_message)
6019: SELECT
6020: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6021: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6022: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'LIST_LINE_TYPE_CODE',
6023: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null, l_msg_txt
6024: FROM QP_INTERFACE_LIST_LINES qpil

Line 6021: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6017: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6018: orig_sys_pricing_attr_ref,error_message)
6019: SELECT
6020: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6021: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6022: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'LIST_LINE_TYPE_CODE',
6023: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null, l_msg_txt
6024: FROM QP_INTERFACE_LIST_LINES qpil
6025: WHERE qpil.request_id = p_request_id

Line 6047: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6043: program_id, program_update_date, entity_type, table_name, column_name,
6044: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6045: orig_sys_pricing_attr_ref,error_message)
6046: SELECT
6047: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6048: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6049: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'ARITHMETIC_OPERATOR',
6050: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6051: FROM QP_INTERFACE_LIST_LINES qpil

Line 6048: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6044: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6045: orig_sys_pricing_attr_ref,error_message)
6046: SELECT
6047: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6048: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6049: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'ARITHMETIC_OPERATOR',
6050: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6051: FROM QP_INTERFACE_LIST_LINES qpil
6052: WHERE qpil.request_id = p_request_id

Line 6073: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6069: program_id, program_update_date, entity_type, table_name, column_name,
6070: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6071: orig_sys_pricing_attr_ref,error_message)
6072: SELECT
6073: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6074: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6075: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BREAK_TYPE_CODE',
6076: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6077: FROM QP_INTERFACE_LIST_LINES qpil

Line 6074: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6070: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6071: orig_sys_pricing_attr_ref,error_message)
6072: SELECT
6073: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6074: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6075: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BREAK_TYPE_CODE',
6076: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6077: FROM QP_INTERFACE_LIST_LINES qpil
6078: WHERE qpil.request_id = p_request_id

Line 6101: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6097: program_id, program_update_date, entity_type, table_name, column_name,
6098: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6099: orig_sys_pricing_attr_ref,error_message)
6100: SELECT /*+ index(qpip QP_INTERFACE_PRCNG_ATTRIBS_N4) */
6101: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6102: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6103: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6104: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6105: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6102: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6098: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6099: orig_sys_pricing_attr_ref,error_message)
6100: SELECT /*+ index(qpip QP_INTERFACE_PRCNG_ATTRIBS_N4) */
6101: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6102: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6103: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6104: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6105: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6106: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh

Line 6187: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6183: program_id, program_update_date, entity_type, table_name, column_name,
6184: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6185: orig_sys_pricing_attr_ref,error_message)
6186: SELECT
6187: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6188: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6189: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6190: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6191: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6188: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6184: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6185: orig_sys_pricing_attr_ref,error_message)
6186: SELECT
6187: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6188: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6189: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6190: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6191: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6192: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh

Line 6230: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6226: program_id, program_update_date, entity_type, table_name, column_name,
6227: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6228: orig_sys_pricing_attr_ref,error_message)
6229: SELECT
6230: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6231: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6232: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_AND_GENERATE_FORMULA_ID',
6233: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6234: FROM QP_INTERFACE_LIST_LINES qpil

Line 6231: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6227: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6228: orig_sys_pricing_attr_ref,error_message)
6229: SELECT
6230: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6231: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6232: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_AND_GENERATE_FORMULA_ID',
6233: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6234: FROM QP_INTERFACE_LIST_LINES qpil
6235: WHERE qpil.request_id = p_request_id

Line 6259: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6255: program_id, program_update_date, entity_type, table_name, column_name,
6256: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6257: orig_sys_pricing_attr_ref,error_message)
6258: SELECT
6259: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6260: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6261: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6262: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6263: FROM QP_INTERFACE_LIST_LINES qpil

Line 6260: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6256: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6257: orig_sys_pricing_attr_ref,error_message)
6258: SELECT
6259: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6260: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6261: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6262: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6263: FROM QP_INTERFACE_LIST_LINES qpil
6264: WHERE qpil.request_id = p_request_id

Line 6282: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6278: program_id, program_update_date, entity_type, table_name, column_name,
6279: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6280: orig_sys_pricing_attr_ref,error_message)
6281: SELECT
6282: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6283: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6284: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6285: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6286: FROM QP_INTERFACE_LIST_LINES qpil

Line 6283: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6279: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6280: orig_sys_pricing_attr_ref,error_message)
6281: SELECT
6282: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6283: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6284: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6285: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6286: FROM QP_INTERFACE_LIST_LINES qpil
6287: WHERE qpil.request_id = p_request_id

Line 6303: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6299: program_id, program_update_date, entity_type, table_name, column_name,
6300: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6301: orig_sys_pricing_attr_ref,error_message)
6302: SELECT
6303: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6304: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6305: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6306: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6307: FROM QP_INTERFACE_LIST_LINES qpil

Line 6304: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6300: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6301: orig_sys_pricing_attr_ref,error_message)
6302: SELECT
6303: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6304: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6305: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6306: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6307: FROM QP_INTERFACE_LIST_LINES qpil
6308: WHERE qpil.request_id = p_request_id

Line 6333: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6329: program_id, program_update_date, entity_type, table_name, column_name,
6330: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6331: orig_sys_pricing_attr_ref,error_message)
6332: SELECT
6333: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6334: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6335: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6336: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6337: FROM QP_INTERFACE_LIST_LINES qpil

Line 6334: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6330: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6331: orig_sys_pricing_attr_ref,error_message)
6332: SELECT
6333: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6334: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6335: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6336: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6337: FROM QP_INTERFACE_LIST_LINES qpil
6338: WHERE qpil.request_id = p_request_id

Line 6365: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6361: program_id, program_update_date, entity_type, table_name, column_name,
6362: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6363: orig_sys_pricing_attr_ref,error_message)
6364: SELECT
6365: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6366: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6367: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6368: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6369: FROM QP_INTERFACE_LIST_LINES qpil

Line 6366: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6362: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6363: orig_sys_pricing_attr_ref,error_message)
6364: SELECT
6365: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6366: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6367: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6368: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6369: FROM QP_INTERFACE_LIST_LINES qpil
6370: WHERE qpil.request_id = p_request_id

Line 6386: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6382: program_id, program_update_date, entity_type, table_name, column_name,
6383: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6384: orig_sys_pricing_attr_ref,error_message)
6385: SELECT
6386: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6387: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6388: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6389: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6390: FROM QP_INTERFACE_LIST_LINES qpil

Line 6387: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6383: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6384: orig_sys_pricing_attr_ref,error_message)
6385: SELECT
6386: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6387: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6388: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6389: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6390: FROM QP_INTERFACE_LIST_LINES qpil
6391: WHERE qpil.request_id = p_request_id

Line 6421: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6417: program_id, program_update_date, entity_type, table_name,
6418: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6419: orig_sys_pricing_attr_ref,error_message)
6420: SELECT
6421: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6422: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6423: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES',
6424: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6425: FROM QP_INTERFACE_LIST_LINES qpil

Line 6422: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6418: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6419: orig_sys_pricing_attr_ref,error_message)
6420: SELECT
6421: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6422: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6423: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES',
6424: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6425: FROM QP_INTERFACE_LIST_LINES qpil
6426: WHERE qpil.request_id = p_request_id

Line 6446: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6442: program_id, program_update_date, entity_type, table_name, column_name,
6443: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6444: orig_sys_pricing_attr_ref,error_message)
6445: SELECT
6446: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6447: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6448: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6449: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6450: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6447: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6443: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6444: orig_sys_pricing_attr_ref,error_message)
6445: SELECT
6446: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6447: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6448: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6449: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6450: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6451: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

Line 6495: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6491: program_id, program_update_date, entity_type, table_name, column_name,
6492: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6493: orig_sys_pricing_attr_ref,error_message)
6494: SELECT
6495: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6496: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6497: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6498: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6499: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6496: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6492: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6493: orig_sys_pricing_attr_ref,error_message)
6494: SELECT
6495: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6496: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6497: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6498: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6499: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6500: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

Line 6528: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6524: program_id, program_update_date, entity_type, table_name, column_name,
6525: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6526: orig_sys_pricing_attr_ref,error_message)
6527: SELECT
6528: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6529: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6530: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6531: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6532: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6529: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6525: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6526: orig_sys_pricing_attr_ref,error_message)
6527: SELECT
6528: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6529: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6530: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6531: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6532: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6533: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

Line 6560: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6556: program_id, program_update_date, entity_type, table_name, column_name,
6557: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6558: orig_sys_pricing_attr_ref,error_message)
6559: SELECT
6560: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6561: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6562: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6563: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6564: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6561: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6557: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6558: orig_sys_pricing_attr_ref,error_message)
6559: SELECT
6560: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6561: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6562: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6563: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6564: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6565: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

Line 6597: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6593: program_id, program_update_date, entity_type, table_name, column_name,
6594: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6595: orig_sys_pricing_attr_ref,error_message)
6596: SELECT
6597: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6598: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6599: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6600: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6601: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6598: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6594: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6595: orig_sys_pricing_attr_ref,error_message)
6596: SELECT
6597: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6598: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6599: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6600: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6601: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6602: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

Line 6630: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6626: program_id, program_update_date, entity_type, table_name, column_name,
6627: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6628: orig_sys_pricing_attr_ref,error_message)
6629: SELECT
6630: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6631: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6632: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6633: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6634: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6631: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6627: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6628: orig_sys_pricing_attr_ref,error_message)
6629: SELECT
6630: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6631: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6632: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6633: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6634: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6635: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

Line 6662: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,

6658: program_id, program_update_date, entity_type, table_name, column_name,
6659: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6660: orig_sys_pricing_attr_ref,error_message)
6661: SELECT
6662: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6663: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6664: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6665: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6666: qpip.orig_sys_pricing_attr_ref, l_msg_txt

Line 6663: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,

6659: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6660: orig_sys_pricing_attr_ref,error_message)
6661: SELECT
6662: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6663: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6664: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6665: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6666: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6667: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip