179: program_id, program_update_date, entity_type, table_name, column_name,
180: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
181: orig_sys_pricing_attr_ref, error_message)
182: VALUES
183: (l_error_id, sysdate ,FND_GLOBAL.USER_ID, sysdate,
184: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 661,
185: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
186: p_orig_sys_header_ref,p_orig_sys_line_ref1,null,null,l_msg);
187: return FALSE;
180: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
181: orig_sys_pricing_attr_ref, error_message)
182: VALUES
183: (l_error_id, sysdate ,FND_GLOBAL.USER_ID, sysdate,
184: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id, 661,
185: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
186: p_orig_sys_header_ref,p_orig_sys_line_ref1,null,null,l_msg);
187: return FALSE;
188: END IF;
3758: IF p_pricing_attr_rec.product_attribute_context(I)='ITEM' AND
3759: p_pricing_attr_rec.product_attribute(I)= 'PRICING_ATTRIBUTE1'
3760: THEN
3761: l_pa_count :=0;
3762: IF fnd_global.resp_appl_id=178 OR fnd_global.resp_appl_id=201
3763: THEN --Check if item is purchasing enabled
3764: Begin
3765: select count(*) into l_pa_count
3766: from qp_interface_pricing_attribs qipa, mtl_system_items msi
4396: program_id, program_update_date, entity_type, table_name, column_name,
4397: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4398: orig_sys_pricing_attr_ref, error_message)
4399: VALUES
4400: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4401: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4402: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4403: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4404: null,l_msg_txt);
4397: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4398: orig_sys_pricing_attr_ref, error_message)
4399: VALUES
4400: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4401: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4402: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4403: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4404: null,l_msg_txt);
4405:
4460: program_id, program_update_date, entity_type, table_name, column_name,
4461: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4462: orig_sys_pricing_attr_ref, error_message)
4463: VALUES
4464: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4465: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4466: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4467: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4468: null,l_msg_txt);
4461: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4462: orig_sys_pricing_attr_ref, error_message)
4463: VALUES
4464: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4465: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I),661,
4466: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4467: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4468: null,l_msg_txt);
4469:
4581: program_id, program_update_date, entity_type, table_name, column_name,
4582: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4583: orig_sys_pricing_attr_ref, error_message)
4584: VALUES
4585: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4586: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4587: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4588: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4589: null,l_msg_txt);
4582: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4583: orig_sys_pricing_attr_ref, error_message)
4584: VALUES
4585: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4586: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4587: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4588: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4589: null,l_msg_txt);
4590:
4716: program_id, program_update_date, entity_type, table_name, column_name,
4717: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4718: orig_sys_pricing_attr_ref, error_message)
4719: VALUES
4720: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4721: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4722: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4723: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4724: null,l_msg_txt);
4717: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4718: orig_sys_pricing_attr_ref, error_message)
4719: VALUES
4720: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4721: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4722: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4723: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4724: null,l_msg_txt);
4725: END IF;
4743: program_id, program_update_date, entity_type, table_name, column_name,
4744: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4745: orig_sys_pricing_attr_ref, error_message)
4746: VALUES
4747: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4748: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4749: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4750: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4751: null,l_msg_txt);
4744: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4745: orig_sys_pricing_attr_ref, error_message)
4746: VALUES
4747: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4748: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4749: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4750: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4751: null,l_msg_txt);
4752: END IF;
4779: program_id, program_update_date, entity_type, table_name, column_name,
4780: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4781: orig_sys_pricing_attr_ref, error_message)
4782: VALUES
4783: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4784: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4785: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4786: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4787: null,l_msg_txt);
4780: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4781: orig_sys_pricing_attr_ref, error_message)
4782: VALUES
4783: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4784: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4785: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4786: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4787: null,l_msg_txt);
4788: END IF;
4820: program_id, program_update_date, entity_type, table_name, column_name,
4821: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4822: orig_sys_pricing_attr_ref, error_message)
4823: VALUES
4824: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4825: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4826: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4827: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4828: null,l_msg_txt);
4821: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
4822: orig_sys_pricing_attr_ref, error_message)
4823: VALUES
4824: (qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
4825: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_pricing_attr_rec.request_id(I), 661,
4826: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,
4827: p_pricing_attr_rec.orig_sys_header_ref(I),p_pricing_attr_rec.orig_sys_line_ref(I),null,
4828: null,l_msg_txt);
4829:
5115: program_id, program_update_date, entity_type, table_name, column_name,
5116: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5117: orig_sys_pricing_attr_ref, error_message)
5118: SELECT
5119: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5120: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5121: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_CODE',
5122: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5123: FROM QP_INTERFACE_LIST_HEADERS qpih
5116: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5117: orig_sys_pricing_attr_ref, error_message)
5118: SELECT
5119: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5120: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5121: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_CODE',
5122: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5123: FROM QP_INTERFACE_LIST_HEADERS qpih
5124: WHERE qpih.request_id = p_request_id
5146: program_id, program_update_date, entity_type, table_name, column_name,
5147: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5148: orig_sys_pricing_attr_ref, error_message)
5149: SELECT
5150: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5151: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5152: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5153: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5154: FROM QP_INTERFACE_LIST_HEADERS qpih
5147: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5148: orig_sys_pricing_attr_ref, error_message)
5149: SELECT
5150: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5151: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5152: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5153: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5154: FROM QP_INTERFACE_LIST_HEADERS qpih
5155: WHERE qpih.request_id = p_request_id
5171: program_id, program_update_date, entity_type, table_name, column_name,
5172: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5173: orig_sys_pricing_attr_ref, error_message)
5174: SELECT
5175: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5176: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5177: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5178: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5179: FROM QP_INTERFACE_LIST_HEADERS qpih
5172: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5173: orig_sys_pricing_attr_ref, error_message)
5174: SELECT
5175: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5176: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5177: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5178: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5179: FROM QP_INTERFACE_LIST_HEADERS qpih
5180: WHERE qpih.request_id = p_request_id
5194: program_id, program_update_date, entity_type, table_name, column_name,
5195: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5196: orig_sys_pricing_attr_ref, error_message)
5197: SELECT
5198: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5199: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5200: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5201: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5202: FROM QP_INTERFACE_LIST_HEADERS qpih
5195: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5196: orig_sys_pricing_attr_ref, error_message)
5197: SELECT
5198: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5199: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5200: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FREIGHT TERMS',
5201: qpih.orig_sys_header_ref,null,null,null, l_msg_txt
5202: FROM QP_INTERFACE_LIST_HEADERS qpih
5203: WHERE qpih.request_id = p_request_id
5225: program_id, program_update_date, entity_type, table_name, column_name,
5226: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5227: orig_sys_pricing_attr_ref, error_message)
5228: SELECT
5229: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5230: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5231: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'LIST_TYPE_CODE',
5232: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5233: FROM QP_INTERFACE_LIST_HEADERS qpih
5226: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5227: orig_sys_pricing_attr_ref, error_message)
5228: SELECT
5229: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5230: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5231: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'LIST_TYPE_CODE',
5232: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5233: FROM QP_INTERFACE_LIST_HEADERS qpih
5234: WHERE qpih.request_id = p_request_id
5254: program_id, program_update_date, entity_type, table_name, column_name,
5255: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5256: orig_sys_pricing_attr_ref, error_message)
5257: SELECT
5258: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5259: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5260: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5261: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5262: FROM QP_INTERFACE_LIST_HEADERS qpih
5255: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5256: orig_sys_pricing_attr_ref, error_message)
5257: SELECT
5258: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5259: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5260: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5261: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5262: FROM QP_INTERFACE_LIST_HEADERS qpih
5263: WHERE qpih.request_id = p_request_id
5280: program_id, program_update_date, entity_type, table_name, column_name,
5281: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5282: orig_sys_pricing_attr_ref, error_message)
5283: SELECT
5284: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5285: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5286: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5287: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5288: FROM QP_INTERFACE_LIST_HEADERS qpih
5281: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5282: orig_sys_pricing_attr_ref, error_message)
5283: SELECT
5284: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5285: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5286: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5287: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5288: FROM QP_INTERFACE_LIST_HEADERS qpih
5289: WHERE qpih.request_id = p_request_id
5305: program_id, program_update_date, entity_type, table_name, column_name,
5306: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5307: orig_sys_pricing_attr_ref, error_message)
5308: SELECT
5309: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5310: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5311: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5312: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5313: FROM QP_INTERFACE_LIST_HEADERS qpih
5306: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5307: orig_sys_pricing_attr_ref, error_message)
5308: SELECT
5309: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5310: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5311: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'FRIEGHT CARRIER',
5312: qpih.orig_sys_header_ref, null,null,null,l_msg_txt
5313: FROM QP_INTERFACE_LIST_HEADERS qpih
5314: WHERE qpih.request_id = p_request_id
5337: program_id, program_update_date, entity_type, table_name, column_name,
5338: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5339: orig_sys_pricing_attr_ref, error_message)
5340: SELECT
5341: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5342: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5343: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5344: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5345: FROM QP_INTERFACE_LIST_HEADERS qpih
5338: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5339: orig_sys_pricing_attr_ref, error_message)
5340: SELECT
5341: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5342: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5343: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5344: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5345: FROM QP_INTERFACE_LIST_HEADERS qpih
5346: WHERE qpih.request_id = p_request_id
5364: program_id, program_update_date, entity_type, table_name, column_name,
5365: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5366: orig_sys_pricing_attr_ref, error_message)
5367: SELECT
5368: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5369: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5370: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5371: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5372: FROM QP_INTERFACE_LIST_HEADERS qpih
5365: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5366: orig_sys_pricing_attr_ref, error_message)
5367: SELECT
5368: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5369: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5370: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5371: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5372: FROM QP_INTERFACE_LIST_HEADERS qpih
5373: WHERE qpih.request_id = p_request_id
5389: program_id, program_update_date, entity_type, table_name, column_name,
5390: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5391: orig_sys_pricing_attr_ref, error_message)
5392: SELECT
5393: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5394: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5395: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5396: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5397: FROM QP_INTERFACE_LIST_HEADERS qpih
5390: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5391: orig_sys_pricing_attr_ref, error_message)
5392: SELECT
5393: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5394: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5395: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'PAYMENT TERMS',
5396: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5397: FROM QP_INTERFACE_LIST_HEADERS qpih
5398: WHERE qpih.request_id = p_request_id
5427: program_id, program_update_date, entity_type, table_name, column_name,
5428: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5429: orig_sys_pricing_attr_ref, error_message)
5430: SELECT
5431: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5432: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5433: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5434: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5435: FROM QP_INTERFACE_LIST_HEADERS qpih
5428: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5429: orig_sys_pricing_attr_ref, error_message)
5430: SELECT
5431: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5432: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5433: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5434: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5435: FROM QP_INTERFACE_LIST_HEADERS qpih
5436: WHERE qpih.request_id = p_request_id
5453: program_id, program_update_date, entity_type, table_name, column_name,
5454: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5455: orig_sys_pricing_attr_ref, error_message)
5456: SELECT
5457: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5458: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5459: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5460: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5461: FROM QP_INTERFACE_LIST_HEADERS qpih
5454: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5455: orig_sys_pricing_attr_ref, error_message)
5456: SELECT
5457: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5458: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5459: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5460: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5461: FROM QP_INTERFACE_LIST_HEADERS qpih
5462: WHERE qpih.request_id = p_request_id
5478: program_id, program_update_date, entity_type, table_name, column_name,
5479: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5480: orig_sys_pricing_attr_ref, error_message)
5481: SELECT
5482: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5483: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5484: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5485: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5486: FROM QP_INTERFACE_LIST_HEADERS qpih
5479: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5480: orig_sys_pricing_attr_ref, error_message)
5481: SELECT
5482: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5483: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5484: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'CURRENCY_HEADER',
5485: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5486: FROM QP_INTERFACE_LIST_HEADERS qpih
5487: WHERE qpih.request_id = p_request_id
5507: program_id, program_update_date, entity_type, table_name, column_name,
5508: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5509: orig_sys_pricing_attr_ref, error_message)
5510: SELECT
5511: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5512: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5513: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5514: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5515: FROM QP_INTERFACE_LIST_HEADERS qpih
5508: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5509: orig_sys_pricing_attr_ref, error_message)
5510: SELECT
5511: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5512: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5513: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5514: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5515: FROM QP_INTERFACE_LIST_HEADERS qpih
5516: WHERE qpih.request_id = p_request_id
5532: program_id, program_update_date, entity_type, table_name, column_name,
5533: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5534: orig_sys_pricing_attr_ref, error_message)
5535: SELECT
5536: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5537: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5538: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5539: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5540: FROM QP_INTERFACE_LIST_HEADERS qpih
5533: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5534: orig_sys_pricing_attr_ref, error_message)
5535: SELECT
5536: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5537: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5538: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5539: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5540: FROM QP_INTERFACE_LIST_HEADERS qpih
5541: WHERE qpih.request_id = p_request_id
5558: program_id, program_update_date, entity_type, table_name, column_name,
5559: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5560: orig_sys_pricing_attr_ref, error_message)
5561: SELECT
5562: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5563: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5564: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5565: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5566: FROM QP_INTERFACE_LIST_HEADERS qpih
5559: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5560: orig_sys_pricing_attr_ref, error_message)
5561: SELECT
5562: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5563: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5564: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5565: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5566: FROM QP_INTERFACE_LIST_HEADERS qpih
5567: WHERE qpih.request_id = p_request_id
5587: program_id, program_update_date, entity_type, table_name, column_name,
5588: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5589: orig_sys_pricing_attr_ref, error_message)
5590: SELECT
5591: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5592: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5593: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'pte_code',
5594: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5595: FROM QP_INTERFACE_LIST_HEADERS qpih
5588: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5589: orig_sys_pricing_attr_ref, error_message)
5590: SELECT
5591: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5592: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5593: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'pte_code',
5594: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5595: FROM QP_INTERFACE_LIST_HEADERS qpih
5596: WHERE qpih.request_id = p_request_id
5614: program_id, program_update_date, entity_type, table_name, column_name,
5615: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5616: orig_sys_pricing_attr_ref, error_message)
5617: SELECT
5618: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5619: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5620: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5621: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5622: FROM QP_INTERFACE_LIST_HEADERS qpih
5615: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5616: orig_sys_pricing_attr_ref, error_message)
5617: SELECT
5618: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5619: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5620: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5621: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5622: FROM QP_INTERFACE_LIST_HEADERS qpih
5623: WHERE qpih.request_id = p_request_id
5636: program_id, program_update_date, entity_type, table_name, column_name,
5637: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5638: orig_sys_pricing_attr_ref, error_message)
5639: SELECT
5640: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5641: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5642: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5643: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5644: FROM QP_INTERFACE_LIST_HEADERS qpih
5637: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5638: orig_sys_pricing_attr_ref, error_message)
5639: SELECT
5640: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5641: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5642: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5643: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5644: FROM QP_INTERFACE_LIST_HEADERS qpih
5645: WHERE qpih.request_id = p_request_id
5662: program_id, program_update_date, entity_type, table_name, column_name,
5663: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5664: orig_sys_pricing_attr_ref, error_message)
5665: SELECT
5666: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5667: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5668: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5669: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5670: FROM QP_INTERFACE_LIST_HEADERS qpih
5663: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5664: orig_sys_pricing_attr_ref, error_message)
5665: SELECT
5666: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5667: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5668: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'Name',
5669: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5670: FROM QP_INTERFACE_LIST_HEADERS qpih
5671: WHERE qpih.request_id = p_request_id
5686: program_id, program_update_date, entity_type, table_name, column_name,
5687: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5688: orig_sys_pricing_attr_ref, error_message)
5689: SELECT
5690: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5691: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5692: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ROUNDING_FACTOR',
5693: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5694: FROM QP_INTERFACE_LIST_HEADERS qpih
5687: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5688: orig_sys_pricing_attr_ref, error_message)
5689: SELECT
5690: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5691: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5692: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ROUNDING_FACTOR',
5693: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5694: FROM QP_INTERFACE_LIST_HEADERS qpih
5695: WHERE qpih.request_id = p_request_id
5716: program_id, program_update_date, entity_type, table_name, column_name,
5717: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5718: orig_sys_pricing_attr_ref, error_message)
5719: SELECT
5720: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5721: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5722: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
5723: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5724: FROM QP_INTERFACE_LIST_HEADERS qpih
5717: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
5718: orig_sys_pricing_attr_ref, error_message)
5719: SELECT
5720: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
5721: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpih.request_id, 661,
5722: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_HEADERS', 'ORIG_SYS_HEADER_REF',
5723: qpih.orig_sys_header_ref,null,null,null,l_msg_txt
5724: FROM QP_INTERFACE_LIST_HEADERS qpih
5725: WHERE qpih.request_id = p_request_id
5768: program_id, program_update_date, entity_type, table_name, column_name,
5769: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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
5769: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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
5795: program_id, program_update_date, entity_type, table_name, column_name,
5796: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_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
5796: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_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
5827: program_id, program_update_date, entity_type, table_name,
5828: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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
5828: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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
5853: program_id, program_update_date, entity_type, table_name,
5854: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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
5854: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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
5878: program_id, program_update_date, entity_type, table_name, column_name,
5879: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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
5879: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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
5912: program_id, program_update_date, entity_type, table_name, column_name,
5913: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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
5913: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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
5945: program_id, program_update_date, entity_type, table_name, column_name,
5946: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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
5946: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
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
6028: program_id, program_update_date, entity_type, table_name, column_name,
6029: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6030: orig_sys_pricing_attr_ref,error_message)
6031: SELECT
6032: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6033: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6034: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'LIST_LINE_TYPE_CODE',
6035: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null, l_msg_txt
6036: FROM QP_INTERFACE_LIST_LINES qpil
6029: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6030: orig_sys_pricing_attr_ref,error_message)
6031: SELECT
6032: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6033: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6034: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'LIST_LINE_TYPE_CODE',
6035: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null, l_msg_txt
6036: FROM QP_INTERFACE_LIST_LINES qpil
6037: WHERE qpil.request_id = p_request_id
6055: program_id, program_update_date, entity_type, table_name, column_name,
6056: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6057: orig_sys_pricing_attr_ref,error_message)
6058: SELECT
6059: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6060: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6061: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'ARITHMETIC_OPERATOR',
6062: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6063: FROM QP_INTERFACE_LIST_LINES qpil
6056: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6057: orig_sys_pricing_attr_ref,error_message)
6058: SELECT
6059: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6060: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6061: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'ARITHMETIC_OPERATOR',
6062: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6063: FROM QP_INTERFACE_LIST_LINES qpil
6064: WHERE qpil.request_id = p_request_id
6081: program_id, program_update_date, entity_type, table_name, column_name,
6082: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6083: orig_sys_pricing_attr_ref,error_message)
6084: SELECT
6085: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6086: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6087: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BREAK_TYPE_CODE',
6088: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6089: FROM QP_INTERFACE_LIST_LINES qpil
6082: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6083: orig_sys_pricing_attr_ref,error_message)
6084: SELECT
6085: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6086: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6087: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BREAK_TYPE_CODE',
6088: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6089: FROM QP_INTERFACE_LIST_LINES qpil
6090: WHERE qpil.request_id = p_request_id
6109: program_id, program_update_date, entity_type, table_name, column_name,
6110: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6111: orig_sys_pricing_attr_ref,error_message)
6112: SELECT /*+ index(qpip QP_INTERFACE_PRCNG_ATTRIBS_N4) */
6113: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6114: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6115: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6116: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6117: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6110: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6111: orig_sys_pricing_attr_ref,error_message)
6112: SELECT /*+ index(qpip QP_INTERFACE_PRCNG_ATTRIBS_N4) */
6113: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6114: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6115: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6116: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6117: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6118: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6195: program_id, program_update_date, entity_type, table_name, column_name,
6196: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6197: orig_sys_pricing_attr_ref,error_message)
6198: SELECT
6199: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6200: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6201: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6202: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6203: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6196: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6197: orig_sys_pricing_attr_ref,error_message)
6198: SELECT
6199: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6200: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6201: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6202: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6203: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6204: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6238: program_id, program_update_date, entity_type, table_name, column_name,
6239: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6240: orig_sys_pricing_attr_ref,error_message)
6241: SELECT
6242: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6243: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6244: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_AND_GENERATE_FORMULA_ID',
6245: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6246: FROM QP_INTERFACE_LIST_LINES qpil
6239: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6240: orig_sys_pricing_attr_ref,error_message)
6241: SELECT
6242: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6243: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6244: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_AND_GENERATE_FORMULA_ID',
6245: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6246: FROM QP_INTERFACE_LIST_LINES qpil
6247: WHERE qpil.request_id = p_request_id
6267: program_id, program_update_date, entity_type, table_name, column_name,
6268: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6269: orig_sys_pricing_attr_ref,error_message)
6270: SELECT
6271: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6272: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6273: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6274: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6275: FROM QP_INTERFACE_LIST_LINES qpil
6268: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6269: orig_sys_pricing_attr_ref,error_message)
6270: SELECT
6271: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6272: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6273: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6274: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6275: FROM QP_INTERFACE_LIST_LINES qpil
6276: WHERE qpil.request_id = p_request_id
6290: program_id, program_update_date, entity_type, table_name, column_name,
6291: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6292: orig_sys_pricing_attr_ref,error_message)
6293: SELECT
6294: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6295: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6296: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6297: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6298: FROM QP_INTERFACE_LIST_LINES qpil
6291: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6292: orig_sys_pricing_attr_ref,error_message)
6293: SELECT
6294: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6295: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6296: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6297: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6298: FROM QP_INTERFACE_LIST_LINES qpil
6299: WHERE qpil.request_id = p_request_id
6311: program_id, program_update_date, entity_type, table_name, column_name,
6312: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6313: orig_sys_pricing_attr_ref,error_message)
6314: SELECT
6315: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6316: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6317: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6318: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6319: FROM QP_INTERFACE_LIST_LINES qpil
6312: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6313: orig_sys_pricing_attr_ref,error_message)
6314: SELECT
6315: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6316: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6317: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6318: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6319: FROM QP_INTERFACE_LIST_LINES qpil
6320: WHERE qpil.request_id = p_request_id
6341: program_id, program_update_date, entity_type, table_name, column_name,
6342: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6343: orig_sys_pricing_attr_ref,error_message)
6344: SELECT
6345: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6346: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6347: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6348: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6349: FROM QP_INTERFACE_LIST_LINES qpil
6342: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6343: orig_sys_pricing_attr_ref,error_message)
6344: SELECT
6345: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6346: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6347: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6348: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6349: FROM QP_INTERFACE_LIST_LINES qpil
6350: WHERE qpil.request_id = p_request_id
6373: program_id, program_update_date, entity_type, table_name, column_name,
6374: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6375: orig_sys_pricing_attr_ref,error_message)
6376: SELECT
6377: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6378: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6379: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6380: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6381: FROM QP_INTERFACE_LIST_LINES qpil
6374: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6375: orig_sys_pricing_attr_ref,error_message)
6376: SELECT
6377: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6378: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6379: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6380: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6381: FROM QP_INTERFACE_LIST_LINES qpil
6382: WHERE qpil.request_id = p_request_id
6394: program_id, program_update_date, entity_type, table_name, column_name,
6395: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6396: orig_sys_pricing_attr_ref,error_message)
6397: SELECT
6398: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6399: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6400: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6401: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6402: FROM QP_INTERFACE_LIST_LINES qpil
6395: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6396: orig_sys_pricing_attr_ref,error_message)
6397: SELECT
6398: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6399: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6400: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6401: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6402: FROM QP_INTERFACE_LIST_LINES qpil
6403: WHERE qpil.request_id = p_request_id
6429: program_id, program_update_date, entity_type, table_name,
6430: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6431: orig_sys_pricing_attr_ref,error_message)
6432: SELECT
6433: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6434: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6435: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES',
6436: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6437: FROM QP_INTERFACE_LIST_LINES qpil
6430: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6431: orig_sys_pricing_attr_ref,error_message)
6432: SELECT
6433: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6434: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6435: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES',
6436: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6437: FROM QP_INTERFACE_LIST_LINES qpil
6438: WHERE qpil.request_id = p_request_id
6454: program_id, program_update_date, entity_type, table_name, column_name,
6455: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6456: orig_sys_pricing_attr_ref,error_message)
6457: SELECT
6458: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6459: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6460: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6461: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6462: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6455: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6456: orig_sys_pricing_attr_ref,error_message)
6457: SELECT
6458: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6459: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6460: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6461: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6462: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6463: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6503: program_id, program_update_date, entity_type, table_name, column_name,
6504: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6505: orig_sys_pricing_attr_ref,error_message)
6506: SELECT
6507: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6508: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6509: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6510: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6511: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6504: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6505: orig_sys_pricing_attr_ref,error_message)
6506: SELECT
6507: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6508: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6509: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6510: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6511: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6512: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6536: program_id, program_update_date, entity_type, table_name, column_name,
6537: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6538: orig_sys_pricing_attr_ref,error_message)
6539: SELECT
6540: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6541: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6542: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6543: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6544: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6537: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6538: orig_sys_pricing_attr_ref,error_message)
6539: SELECT
6540: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6541: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6542: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6543: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6544: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6545: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6568: program_id, program_update_date, entity_type, table_name, column_name,
6569: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6570: orig_sys_pricing_attr_ref,error_message)
6571: SELECT
6572: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6573: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6574: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6575: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6576: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6569: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6570: orig_sys_pricing_attr_ref,error_message)
6571: SELECT
6572: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6573: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6574: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6575: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6576: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6577: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6605: program_id, program_update_date, entity_type, table_name, column_name,
6606: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6607: orig_sys_pricing_attr_ref,error_message)
6608: SELECT
6609: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6610: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6611: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6612: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6613: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6606: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6607: orig_sys_pricing_attr_ref,error_message)
6608: SELECT
6609: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6610: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6611: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6612: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6613: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6614: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6638: program_id, program_update_date, entity_type, table_name, column_name,
6639: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6640: orig_sys_pricing_attr_ref,error_message)
6641: SELECT
6642: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6643: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6644: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6645: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6646: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6639: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6640: orig_sys_pricing_attr_ref,error_message)
6641: SELECT
6642: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6643: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6644: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6645: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6646: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6647: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6670: program_id, program_update_date, entity_type, table_name, column_name,
6671: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6672: orig_sys_pricing_attr_ref,error_message)
6673: SELECT
6674: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6675: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6676: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6677: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6678: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6671: orig_sys_header_ref,orig_sys_line_ref,orig_sys_qualifier_ref,
6672: orig_sys_pricing_attr_ref,error_message)
6673: SELECT
6674: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6675: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6676: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6677: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6678: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6679: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip