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

APPS.QP_BULK_VALIDATE dependencies on QP_INTERFACE_LIST_LINES

Line 23: from qp_interface_list_lines

19:
20: begin
21: select interface_action_code
22: into l_interface_action_code
23: from qp_interface_list_lines
24: where orig_sys_line_ref = p_orig_sys_line_ref;
25: exception
26: when others then
27: null;

Line 114: From qp_interface_list_lines

110: qp_bulk_loader_pub.write_log('Inside check dates');
111: Begin
112: SELECT start_date_active, end_date_active
113: Into l_sdate, l_edate
114: From qp_interface_list_lines
115: Where orig_sys_line_ref=p_orig_sys_line_ref2;
116: Exception
117: When no_data_found then
118:

Line 163: Update qp_interface_list_lines set process_status_flag=NULL --'E'

159: nvl(p_End_Date_Active,l_max_date) )
160:
161: THEN
162: qp_bulk_loader_pub.write_log('DUP line exists');
163: Update qp_interface_list_lines set process_status_flag=NULL --'E'
164: Where orig_sys_line_ref = p_orig_sys_line_ref1
165: And request_id = p_request_id;
166:
167: fnd_message.set_name('QP','QP_DUPLICATE_LIST_LINES');

Line 185: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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;
189: return TRUE;

Line 568: From qp_interface_list_lines

564: if i_mode = 1 then
565: begin
566: Select 'x'
567: into l_dummy
568: From qp_interface_list_lines
569: where orig_sys_line_ref = l_dup_lin_rec.b_orig_sys_line_ref(I)
570: and price_break_header_ref is not NULL
571: and rltd_modifier_grp_type='PRICE BREAK';
572: Exception

Line 631: From qp_interface_list_lines a

627: into l_start_date_active,
628: l_end_date_active,
629: l1_orig_sys_header_ref,
630: l1_orig_sys_line_ref
631: From qp_interface_list_lines a
632: Where a.orig_sys_line_ref=l_dup_lin_rec.a_orig_sys_line_ref(I);
633:
634: if not check_dates_for_dupl(p_request_id,
635: l_start_date_active,

Line 1899: l_msg_rec.TABLE_NAME :='QP_INTERFACE_LIST_LINES';

1895: --Initially setting the message context.
1896: --qp_bulk_loader_pub.write_log(' In the loop');
1897: l_msg_rec.REQUEST_ID := P_LINE_REC.REQUEST_ID(i);
1898: l_msg_rec.ENTITY_TYPE :='PRL';
1899: l_msg_rec.TABLE_NAME :='QP_INTERFACE_LIST_LINES';
1900: l_msg_rec.ORIG_SYS_HEADER_REF := p_line_rec.orig_sys_header_ref(I);
1901: l_msg_rec.ORIG_SYS_LINE_REF := p_line_rec.orig_sys_line_ref(I);
1902: l_msg_rec.ORIG_SYS_QUALIFIER_REF := NULL;
1903: l_msg_rec.ORIG_SYS_PRICING_ATTR_REF := NULL;

Line 2107: from qp_interface_list_lines

2103:
2104: If p_line_rec.interface_action_code(I)='INSERT' THEN
2105: l_exist:= NULL;
2106: select count(*) into l_exist
2107: from qp_interface_list_lines
2108: where request_id = p_line_rec.request_id(I)
2109: and orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
2110: and orig_sys_header_ref = p_line_rec.orig_sys_header_ref(I);
2111:

Line 2156: FROM qp_interface_list_lines

2152: IF (p_LINE_rec.arithmetic_operator(I) = 'UNIT_PRICE')
2153: THEN
2154: SELECT count(*)
2155: INTO l_dummy
2156: FROM qp_interface_list_lines
2157: WHERE price_break_header_ref = p_LINE_rec.orig_sys_line_ref(I)
2158: AND arithmetic_operator = 'BLOCK_PRICE';
2159:
2160: -- if any price breaks are BLOCK

Line 2205: FROM qp_interface_list_lines

2201: -- AND (cl.arithmetic_operator = 'UNIT_PRICE' OR cl.recurring_value IS NOT NULL);
2202: --
2203: SELECT count(*)
2204: INTO l_dummy
2205: FROM qp_interface_list_lines
2206: WHERE price_break_header_ref = p_LINE_rec.orig_sys_line_ref(I)
2207: AND (arithmetic_operator = 'UNIT_PRICE' OR recurring_value IS NOT NULL);
2208:
2209: IF (l_dummy > 0) THEN

Line 2276: FROM QP_INTERFACE_LIST_LINES

2272:
2273: BEGIN
2274: SELECT price_break_type_code, arithmetic_operator
2275: INTO l_pb_type_code, l_art_opr
2276: FROM QP_INTERFACE_LIST_LINES
2277: WHERE orig_sys_line_ref = p_line_rec.price_break_header_ref(I)
2278: AND orig_sys_header_ref = p_line_rec.orig_sys_header_ref(I)
2279: AND request_id = p_line_rec.request_id(I);
2280: --Bug 4405737 START RAVI

Line 2535: from qp_interface_list_lines

2531: THEN
2532: BEGIN
2533: select start_date_active, end_date_active
2534: into l_PBH_start_date, l_PBH_end_date
2535: from qp_interface_list_lines
2536: where orig_sys_line_ref=p_line_rec.PRICE_BREAK_HEADER_REF(I)
2537: -- Bug 5246745 Use Composite Index for Ref columns
2538: and orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2539: and request_id=p_line_rec.request_id(I)

Line 4384: UPDATE qp_interface_list_lines

4380: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
4381: QP_BULK_MSG.Add(l_msg_rec);
4382:
4383: -- set the corresponding line as errored
4384: UPDATE qp_interface_list_lines
4385: SET process_status_flag = NULL --'E'
4386: WHERE request_id = p_pricing_attr_rec.request_id(I)
4387: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4388: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);

Line 4402: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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:
4406: FOR J IN p_pricing_attr_rec.orig_sys_line_ref.first

Line 4448: UPDATE qp_interface_list_lines

4444: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
4445: QP_BULK_MSG.Add(l_msg_rec);
4446:
4447: -- set the corresponding line as errored
4448: UPDATE qp_interface_list_lines
4449: SET process_status_flag = NULL --'E'
4450: WHERE request_id = p_pricing_attr_rec.request_id(I)
4451: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4452: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);

Line 4466: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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:
4470: FOR J IN p_pricing_attr_rec.orig_sys_line_ref.first

Line 4571: UPDATE qp_interface_list_lines

4567: P_PRICING_ATTR_REC.PROCESS_STATUS_FLAG(I):= NULL; --'E';
4568: FND_MESSAGE.SET_NAME('QP', 'QP_MULT_PRICE_BREAK_ATTRS');
4569: QP_BULK_MSG.ADD(l_msg_rec);
4570:
4571: UPDATE qp_interface_list_lines
4572: SET process_status_flag = NULL --'E'
4573: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4574: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
4575:

Line 4587: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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:
4591: END IF;

Line 4705: UPDATE qp_interface_list_lines

4701: P_PRICING_ATTR_REC.PROCESS_STATUS_FLAG(I):= NULL ; --'E';
4702: FND_MESSAGE.SET_NAME('QP', 'QP_PBK_CRSPNDNG_TO_FROM');
4703: QP_BULK_MSG.ADD(l_msg_rec);
4704:
4705: UPDATE qp_interface_list_lines
4706: SET process_status_flag = NULL --'E'
4707: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4708: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
4709:

Line 4722: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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;
4726: ELSE

Line 4732: UPDATE qp_interface_list_lines

4728: P_PRICING_ATTR_REC.PROCESS_STATUS_FLAG(I):= NULL ; --'E';
4729: FND_MESSAGE.SET_NAME('QP', 'QP_PBK_CRSPNDNG_FROM_TO');
4730: QP_BULK_MSG.ADD(l_msg_rec);
4731:
4732: UPDATE qp_interface_list_lines
4733: SET process_status_flag = NULL --'E'
4734: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4735: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
4736:

Line 4749: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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;
4753: END IF;

Line 4768: UPDATE qp_interface_list_lines

4764: P_PRICING_ATTR_REC.PROCESS_STATUS_FLAG(I):= NULL ; --'E';
4765: FND_MESSAGE.SET_NAME('QP', 'QP_PBK_ZERO_FROM');
4766: QP_BULK_MSG.ADD(l_msg_rec);
4767:
4768: UPDATE qp_interface_list_lines
4769: SET process_status_flag = NULL --'E'
4770: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4771: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
4772:

Line 4785: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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;
4789: END IF;

Line 4809: UPDATE qp_interface_list_lines

4805: P_PRICING_ATTR_REC.PROCESS_STATUS_FLAG(I):= NULL ; --'E';
4806: FND_MESSAGE.SET_NAME('QP', 'QP_OVERLAP_PRICE_BREAK_RANGE');
4807: QP_BULK_MSG.ADD(l_msg_rec);
4808:
4809: UPDATE qp_interface_list_lines
4810: SET process_status_flag = NULL --'E'
4811: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4812: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
4813:

Line 4826: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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:
4830: END IF;

Line 6034: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'LIST_LINE_TYPE_CODE',

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
6038: AND qpil.process_status_flag ='P' --is null

Line 6036: FROM QP_INTERFACE_LIST_LINES qpil

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
6038: AND qpil.process_status_flag ='P' --is null
6039: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6040: AND qpil.list_line_type_code is NOT NULL

Line 6061: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'ARITHMETIC_OPERATOR',

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
6065: AND qpil.process_status_flag ='P' --is null

Line 6063: FROM QP_INTERFACE_LIST_LINES qpil

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
6065: AND qpil.process_status_flag ='P' --is null
6066: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6067: AND qpil.arithmetic_operator is NOT NULL

Line 6087: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BREAK_TYPE_CODE',

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
6091: AND qpil.process_status_flag ='P' --is null

Line 6089: FROM QP_INTERFACE_LIST_LINES qpil

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
6091: AND qpil.process_status_flag ='P' --is null
6092: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6093: AND qpil.price_break_type_code is NOT NULL

Line 6118: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh

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
6119: WHERE qpil.request_id = p_request_id
6120: AND qpip.request_id = p_request_id -- bug no 5881528
6121: AND qpil.process_status_flag ='P' --is null
6122: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6204: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh

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
6205: WHERE qpil.request_id = p_request_id
6206: AND qpip.request_id = p_request_id -- bug no 5881528
6207: AND qpil.process_status_flag ='P' --is null
6208: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6244: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_AND_GENERATE_FORMULA_ID',

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
6248: AND qpil.process_status_flag ='P' --is null

Line 6246: FROM QP_INTERFACE_LIST_LINES qpil

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
6248: AND qpil.process_status_flag ='P' --is null
6249: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6250: AND qpil.price_by_formula_id is NOT NULL

Line 6273: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',

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
6277: AND qpil.process_status_flag ='P' --is null

Line 6275: FROM QP_INTERFACE_LIST_LINES qpil

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
6277: AND qpil.process_status_flag ='P' --is null
6278: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6279: AND qpil.price_by_formula_id is NOT NULL

Line 6296: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',

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
6300: AND qpil.process_status_flag ='P' --is null

Line 6298: FROM QP_INTERFACE_LIST_LINES qpil

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
6300: AND qpil.process_status_flag ='P' --is null
6301: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6302: AND qpil.price_by_formula_id is NOT NULL

Line 6317: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',

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
6321: AND qpil.process_status_flag ='P' --is null

Line 6319: FROM QP_INTERFACE_LIST_LINES qpil

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
6321: AND qpil.process_status_flag ='P' --is null
6322: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6323: AND qpil.price_by_formula_id is NULL

Line 6347: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',

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
6351: AND qpil.process_status_flag ='P' --is null

Line 6349: FROM QP_INTERFACE_LIST_LINES qpil

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
6351: AND qpil.process_status_flag ='P' --is null
6352: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6353: AND qpil.generate_using_formula_id is NOT NULL

Line 6379: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',

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
6383: AND qpil.process_status_flag ='P' --is null

Line 6381: FROM QP_INTERFACE_LIST_LINES qpil

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
6383: AND qpil.process_status_flag ='P' --is null
6384: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6385: AND qpil.generate_using_formula_id is NOT NULL

Line 6400: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',

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
6404: AND qpil.process_status_flag ='P' --is null

Line 6402: FROM QP_INTERFACE_LIST_LINES qpil

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
6404: AND qpil.process_status_flag ='P' --is null
6405: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6406: AND qpil.generate_using_formula_id is NULL

Line 6435: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES',

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
6439: AND qpil.process_status_flag ='P' --is null

Line 6437: FROM QP_INTERFACE_LIST_LINES qpil

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
6439: AND qpil.process_status_flag ='P' --is null
6440: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6441: AND (qpil.list_line_type_code = 'PBH'

Line 6460: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',

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
6464: WHERE qpil.request_id = p_request_id

Line 6463: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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
6464: WHERE qpil.request_id = p_request_id
6465: AND qpip.request_id = p_request_id -- bug no 5881528
6466: AND qpil.process_status_flag ='P' --is null
6467: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6509: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',

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
6513: WHERE qpil.request_id = p_request_id

Line 6512: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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
6513: WHERE qpil.request_id = p_request_id
6514: AND qpip.request_id = p_request_id -- bug no 5881528
6515: AND qpil.process_status_flag ='P' --is null
6516: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6542: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',

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
6546: WHERE qpil.request_id = p_request_id

Line 6545: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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
6546: WHERE qpil.request_id = p_request_id
6547: AND qpip.request_id = p_request_id -- bug no 5881528
6548: AND qpil.process_status_flag ='P' --is null
6549: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6574: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',

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
6578: WHERE qpil.request_id = p_request_id

Line 6577: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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
6578: WHERE qpil.request_id = p_request_id
6579: AND qpip.request_id = p_request_id -- bug no 5881528
6580: AND qpil.process_status_flag ='P' --is null
6581: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6611: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',

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
6615: WHERE qpil.request_id = p_request_id

Line 6614: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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
6615: WHERE qpil.request_id = p_request_id
6616: AND qpip.request_id = p_request_id -- bug no 5881528
6617: AND qpil.process_status_flag ='P' --is null
6618: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6644: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',

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
6648: WHERE qpil.request_id = p_request_id

Line 6647: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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
6648: WHERE qpil.request_id = p_request_id
6649: AND qpip.request_id = p_request_id -- bug no 5881528
6650: AND qpil.process_status_flag ='P' --is null
6651: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6676: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',

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
6680: WHERE qpil.request_id = p_request_id

Line 6679: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

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
6680: WHERE qpil.request_id = p_request_id
6681: AND qpip.request_id = p_request_id -- bug no 5881528
6682: AND qpil.process_status_flag ='P' --is null
6683: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6745: UPDATE qp_interface_list_lines l

6741: AND e.request_id = p_request_id);
6742:
6743: ELSIF p_table_type = 'LINE' THEN
6744:
6745: UPDATE qp_interface_list_lines l
6746: SET process_status_flag = NULL --'E'
6747: WHERE l.request_id =p_request_id
6748: AND EXISTS
6749: (SELECT orig_sys_line_ref

Line 6753: AND table_name ='QP_INTERFACE_LIST_LINES'

6749: (SELECT orig_sys_line_ref
6750: FROM qp_interface_errors e
6751: WHERE e.orig_sys_line_ref = l.orig_sys_line_ref
6752: AND e.orig_sys_header_ref = l.orig_sys_header_ref
6753: AND table_name ='QP_INTERFACE_LIST_LINES'
6754: AND e.request_id = p_request_id );
6755:
6756: ELSIF p_table_type = 'PRICING_ATTRIBS' THEN
6757: