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.

[Home] [Help]

APPS.QP_BULK_VALIDATE dependencies on QP_INTERFACE_LIST_LINES

Line 41: FROM qp_interface_list_lines a

37: --fetching dates for first line, that will be in interface table
38: BEGIN
39: SELECT Nvl(a.start_date_active, l_min_date), Nvl(a.end_date_active, l_max_date)
40: INTO l_a_start_date_active, l_a_end_date_active
41: FROM qp_interface_list_lines a
42: WHERE a.orig_sys_header_ref = p_orig_sys_header_ref
43: AND a.orig_sys_line_ref = p_orig_sys_line_ref_a
44: AND a.request_id = p_request_id;
45: EXCEPTION

Line 48: qp_bulk_loader_pub.write_log(l_routine || 'no line in qp_interface_list_lines for ' || p_orig_sys_line_ref_a);

44: AND a.request_id = p_request_id;
45: EXCEPTION
46: WHEN No_Data_Found
47: THEN
48: qp_bulk_loader_pub.write_log(l_routine || 'no line in qp_interface_list_lines for ' || p_orig_sys_line_ref_a);
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: WHEN OTHERS
51: THEN
52: qp_bulk_loader_pub.write_log(l_routine || '#100 Unexpected exception ' || SQLERRM);

Line 60: FROM qp_interface_list_lines a

56: --fetching dates for second line, that can be either in interface table or setup table
57: BEGIN --begin1
58: SELECT Nvl(a.start_date_active, l_min_date), Nvl(a.end_date_active, l_max_date)
59: INTO l_b_start_date_active, l_b_end_date_active
60: FROM qp_interface_list_lines a
61: WHERE a.orig_sys_header_ref = p_orig_sys_header_ref
62: AND a.orig_sys_line_ref = p_orig_sys_line_ref_b
63: AND a.request_id = p_request_id;
64: EXCEPTION --begin1

Line 76: qp_bulk_loader_pub.write_log(l_routine || ' date not found in qp_list_lines and qp_interface_list_lines');

72: AND a.orig_sys_line_ref = p_orig_sys_line_ref_b;
73: EXCEPTION --begin2
74: WHEN No_Data_Found
75: THEN
76: qp_bulk_loader_pub.write_log(l_routine || ' date not found in qp_list_lines and qp_interface_list_lines');
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END; --begin2
79: END; --begin1
80:

Line 116: UPDATE qp_interface_list_lines

112: l_error_id NUMBER;
113:
114: l_routine VARCHAR2(230) := 'MARK_DUP_LINE ';
115: BEGIN
116: UPDATE qp_interface_list_lines
117: SET process_status_flag = NULL --process_status_flag = NULL means, line errored out
118: WHERE orig_sys_header_ref = p_orig_sys_header_ref
119: AND orig_sys_line_ref = p_orig_sys_line_ref
120: AND request_id = p_request_id;

Line 137: 'QP_INTERFACE_LIST_LINES', NULL, p_orig_sys_header_ref, p_orig_sys_line_ref,

133: orig_sys_qualifier_ref, orig_sys_pricing_attr_ref, error_message)
134: VALUES(l_error_id, SYSDATE, FND_GLOBAL.USER_ID,
135: SYSDATE, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, p_request_id,
136: 661, NULL, NULL, 'PRL',
137: 'QP_INTERFACE_LIST_LINES', NULL, p_orig_sys_header_ref, p_orig_sys_line_ref,
138: NULL, NULL, l_msg);
139:
140: EXCEPTION
141: WHEN OTHERS

Line 365: FROM qp_interface_list_lines

361: IF i_mode = 1 --IF1
362: THEN
363: BEGIN
364: SELECT 'X' INTO l_dummy
365: FROM qp_interface_list_lines
366: WHERE orig_sys_line_ref = l_dup_line_rec.b_orig_sys_line_ref(i)
367: AND price_break_header_ref IS NOT NULL
368: AND rltd_modifier_grp_type = 'PRICE BREAK'; --test this
369: EXCEPTION

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

1739: --Initially setting the message context.
1740: --qp_bulk_loader_pub.write_log(' In the loop');
1741: l_msg_rec.REQUEST_ID := P_LINE_REC.REQUEST_ID(i);
1742: l_msg_rec.ENTITY_TYPE :='PRL';
1743: l_msg_rec.TABLE_NAME :='QP_INTERFACE_LIST_LINES';
1744: l_msg_rec.ORIG_SYS_HEADER_REF := p_line_rec.orig_sys_header_ref(I);
1745: l_msg_rec.ORIG_SYS_LINE_REF := p_line_rec.orig_sys_line_ref(I);
1746: l_msg_rec.ORIG_SYS_QUALIFIER_REF := NULL;
1747: l_msg_rec.ORIG_SYS_PRICING_ATTR_REF := NULL;

Line 1951: from qp_interface_list_lines

1947:
1948: If p_line_rec.interface_action_code(I)='INSERT' THEN
1949: l_exist:= NULL;
1950: select count(*) into l_exist
1951: from qp_interface_list_lines
1952: where request_id = p_line_rec.request_id(I)
1953: and orig_sys_line_ref = p_line_rec.orig_sys_line_ref(I)
1954: and orig_sys_header_ref = p_line_rec.orig_sys_header_ref(I);
1955:

Line 2028: FROM qp_interface_list_lines

2024: IF (p_LINE_rec.arithmetic_operator(I) = 'UNIT_PRICE')
2025: THEN
2026: SELECT count(*)
2027: INTO l_dummy
2028: FROM qp_interface_list_lines
2029: WHERE price_break_header_ref = p_LINE_rec.orig_sys_line_ref(I)
2030: AND arithmetic_operator = 'BLOCK_PRICE';
2031:
2032: -- if any price breaks are BLOCK

Line 2077: FROM qp_interface_list_lines

2073: -- AND (cl.arithmetic_operator = 'UNIT_PRICE' OR cl.recurring_value IS NOT NULL);
2074: --
2075: SELECT count(*)
2076: INTO l_dummy
2077: FROM qp_interface_list_lines
2078: WHERE price_break_header_ref = p_LINE_rec.orig_sys_line_ref(I)
2079: AND (arithmetic_operator = 'UNIT_PRICE' OR recurring_value IS NOT NULL);
2080:
2081: IF (l_dummy > 0) THEN

Line 2148: FROM QP_INTERFACE_LIST_LINES

2144:
2145: BEGIN
2146: SELECT price_break_type_code, arithmetic_operator
2147: INTO l_pb_type_code, l_art_opr
2148: FROM QP_INTERFACE_LIST_LINES
2149: WHERE orig_sys_line_ref = p_line_rec.price_break_header_ref(I)
2150: AND orig_sys_header_ref = p_line_rec.orig_sys_header_ref(I)
2151: AND request_id = p_line_rec.request_id(I);
2152: --Bug 4405737 START RAVI

Line 2407: from qp_interface_list_lines

2403: THEN
2404: BEGIN
2405: select start_date_active, end_date_active
2406: into l_PBH_start_date, l_PBH_end_date
2407: from qp_interface_list_lines
2408: where orig_sys_line_ref=p_line_rec.PRICE_BREAK_HEADER_REF(I)
2409: -- Bug 5246745 Use Composite Index for Ref columns
2410: and orig_sys_header_ref=p_LINE_rec.orig_sys_header_ref(I)
2411: and request_id=p_line_rec.request_id(I)

Line 4370: UPDATE qp_interface_list_lines

4366: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
4367: QP_BULK_MSG.Add(l_msg_rec);
4368:
4369: -- set the corresponding line as errored
4370: UPDATE qp_interface_list_lines
4371: SET process_status_flag = NULL --'E'
4372: WHERE request_id = p_pricing_attr_rec.request_id(I)
4373: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4374: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);

Line 4388: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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

Line 4436: UPDATE qp_interface_list_lines

4432: FND_MESSAGE.SET_NAME('QP','QP_UNIQUE_PRIMARY_UOM');
4433: QP_BULK_MSG.Add(l_msg_rec);
4434:
4435: -- set the corresponding line as errored
4436: UPDATE qp_interface_list_lines
4437: SET process_status_flag = NULL --'E'
4438: WHERE request_id = p_pricing_attr_rec.request_id(I)
4439: AND orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4440: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);

Line 4454: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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

Line 4559: UPDATE qp_interface_list_lines

4555: P_PRICING_ATTR_REC.PROCESS_STATUS_FLAG(I):= NULL; --'E';
4556: FND_MESSAGE.SET_NAME('QP', 'QP_MULT_PRICE_BREAK_ATTRS');
4557: QP_BULK_MSG.ADD(l_msg_rec);
4558:
4559: UPDATE qp_interface_list_lines
4560: SET process_status_flag = NULL --'E'
4561: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4562: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
4563:

Line 4575: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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

Line 4693: UPDATE qp_interface_list_lines

4689: P_PRICING_ATTR_REC.PROCESS_STATUS_FLAG(I):= NULL ; --'E';
4690: FND_MESSAGE.SET_NAME('QP', 'QP_PBK_CRSPNDNG_TO_FROM');
4691: QP_BULK_MSG.ADD(l_msg_rec);
4692:
4693: UPDATE qp_interface_list_lines
4694: SET process_status_flag = NULL --'E'
4695: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4696: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
4697:

Line 4710: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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

Line 4720: UPDATE qp_interface_list_lines

4716: P_PRICING_ATTR_REC.PROCESS_STATUS_FLAG(I):= NULL ; --'E';
4717: FND_MESSAGE.SET_NAME('QP', 'QP_PBK_CRSPNDNG_FROM_TO');
4718: QP_BULK_MSG.ADD(l_msg_rec);
4719:
4720: UPDATE qp_interface_list_lines
4721: SET process_status_flag = NULL --'E'
4722: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4723: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
4724:

Line 4737: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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

Line 4756: UPDATE qp_interface_list_lines

4752: P_PRICING_ATTR_REC.PROCESS_STATUS_FLAG(I):= NULL ; --'E';
4753: FND_MESSAGE.SET_NAME('QP', 'QP_PBK_ZERO_FROM');
4754: QP_BULK_MSG.ADD(l_msg_rec);
4755:
4756: UPDATE qp_interface_list_lines
4757: SET process_status_flag = NULL --'E'
4758: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4759: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
4760:

Line 4773: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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

Line 4797: UPDATE qp_interface_list_lines

4793: P_PRICING_ATTR_REC.PROCESS_STATUS_FLAG(I):= NULL ; --'E';
4794: FND_MESSAGE.SET_NAME('QP', 'QP_OVERLAP_PRICE_BREAK_RANGE');
4795: QP_BULK_MSG.ADD(l_msg_rec);
4796:
4797: UPDATE qp_interface_list_lines
4798: SET process_status_flag = NULL --'E'
4799: WHERE orig_sys_line_ref = p_pricing_attr_rec.orig_sys_line_ref(I)
4800: AND orig_sys_header_ref = p_pricing_attr_rec.orig_sys_header_ref(I);
4801:

Line 4814: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', NULL,

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

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

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

Line 6024: FROM QP_INTERFACE_LIST_LINES qpil

6020: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6021: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6022: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'LIST_LINE_TYPE_CODE',
6023: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null, l_msg_txt
6024: FROM QP_INTERFACE_LIST_LINES qpil
6025: WHERE qpil.request_id = p_request_id
6026: AND qpil.process_status_flag ='P' --is null
6027: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6028: AND qpil.list_line_type_code is NOT NULL

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

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

Line 6051: FROM QP_INTERFACE_LIST_LINES qpil

6047: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6048: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6049: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'ARITHMETIC_OPERATOR',
6050: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6051: FROM QP_INTERFACE_LIST_LINES qpil
6052: WHERE qpil.request_id = p_request_id
6053: AND qpil.process_status_flag ='P' --is null
6054: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6055: AND qpil.arithmetic_operator is NOT NULL

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

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

Line 6077: FROM QP_INTERFACE_LIST_LINES qpil

6073: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6074: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6075: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BREAK_TYPE_CODE',
6076: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6077: FROM QP_INTERFACE_LIST_LINES qpil
6078: WHERE qpil.request_id = p_request_id
6079: AND qpil.process_status_flag ='P' --is null
6080: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6081: AND qpil.price_break_type_code is NOT NULL

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

6102: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6103: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6104: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6105: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6106: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6107: WHERE qpil.request_id = p_request_id
6108: AND qpip.request_id = p_request_id -- bug no 5881528
6109: AND qpil.process_status_flag ='P' --is null
6110: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

6188: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6189: NULL,NULL, 'PRL', 'QP_INTERFACE_PRICING_ATTRIBS', 'PRODUCT_UOM_CODE',
6190: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6191: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6192: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip, QP_LIST_HEADERS_B qplh
6193: WHERE qpil.request_id = p_request_id
6194: AND qpip.request_id = p_request_id -- bug no 5881528
6195: AND qpil.process_status_flag ='P' --is null
6196: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

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

Line 6234: FROM QP_INTERFACE_LIST_LINES qpil

6230: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6231: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6232: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_AND_GENERATE_FORMULA_ID',
6233: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6234: FROM QP_INTERFACE_LIST_LINES qpil
6235: WHERE qpil.request_id = p_request_id
6236: AND qpil.process_status_flag ='P' --is null
6237: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6238: AND qpil.price_by_formula_id is NOT NULL

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

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

Line 6263: FROM QP_INTERFACE_LIST_LINES qpil

6259: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6260: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6261: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6262: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6263: FROM QP_INTERFACE_LIST_LINES qpil
6264: WHERE qpil.request_id = p_request_id
6265: AND qpil.process_status_flag ='P' --is null
6266: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6267: AND qpil.price_by_formula_id is NOT NULL

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

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

Line 6286: FROM QP_INTERFACE_LIST_LINES qpil

6282: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6283: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6284: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6285: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6286: FROM QP_INTERFACE_LIST_LINES qpil
6287: WHERE qpil.request_id = p_request_id
6288: AND qpil.process_status_flag ='P' --is null
6289: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6290: AND qpil.price_by_formula_id is NOT NULL

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

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

Line 6307: FROM QP_INTERFACE_LIST_LINES qpil

6303: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6304: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6305: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRICE_BY_FORMULA_ID',
6306: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6307: FROM QP_INTERFACE_LIST_LINES qpil
6308: WHERE qpil.request_id = p_request_id
6309: AND qpil.process_status_flag ='P' --is null
6310: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6311: AND qpil.price_by_formula_id is NULL

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

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

Line 6337: FROM QP_INTERFACE_LIST_LINES qpil

6333: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6334: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6335: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6336: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6337: FROM QP_INTERFACE_LIST_LINES qpil
6338: WHERE qpil.request_id = p_request_id
6339: AND qpil.process_status_flag ='P' --is null
6340: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6341: AND qpil.generate_using_formula_id is NOT NULL

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

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

Line 6369: FROM QP_INTERFACE_LIST_LINES qpil

6365: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6366: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6367: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6368: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6369: FROM QP_INTERFACE_LIST_LINES qpil
6370: WHERE qpil.request_id = p_request_id
6371: AND qpil.process_status_flag ='P' --is null
6372: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6373: AND qpil.generate_using_formula_id is NOT NULL

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

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

Line 6390: FROM QP_INTERFACE_LIST_LINES qpil

6386: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6387: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6388: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'GENERATE_USING_FORMULA_ID',
6389: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6390: FROM QP_INTERFACE_LIST_LINES qpil
6391: WHERE qpil.request_id = p_request_id
6392: AND qpil.process_status_flag ='P' --is null
6393: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6394: AND qpil.generate_using_formula_id is NULL

Line 6423: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES',

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

Line 6425: FROM QP_INTERFACE_LIST_LINES qpil

6421: qp_interface_errors_s.nextval, sysdate ,FND_GLOBAL.USER_ID, sysdate,
6422: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6423: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES',
6424: qpil.orig_sys_header_ref,qpil.orig_sys_line_ref,null,null,l_msg_txt
6425: FROM QP_INTERFACE_LIST_LINES qpil
6426: WHERE qpil.request_id = p_request_id
6427: AND qpil.process_status_flag ='P' --is null
6428: AND qpil.interface_action_code IN ('INSERT', 'UPDATE')
6429: AND (qpil.list_line_type_code = 'PBH'

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

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

Line 6451: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6447: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6448: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6449: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6450: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6451: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6452: WHERE qpil.request_id = p_request_id
6453: AND qpip.request_id = p_request_id -- bug no 5881528
6454: AND qpil.process_status_flag ='P' --is null
6455: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

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

Line 6500: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6496: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6497: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6498: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6499: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6500: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6501: WHERE qpil.request_id = p_request_id
6502: AND qpip.request_id = p_request_id -- bug no 5881528
6503: AND qpil.process_status_flag ='P' --is null
6504: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

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

Line 6533: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6529: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6530: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6531: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6532: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6533: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6534: WHERE qpil.request_id = p_request_id
6535: AND qpip.request_id = p_request_id -- bug no 5881528
6536: AND qpil.process_status_flag ='P' --is null
6537: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

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

Line 6565: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6561: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6562: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6563: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6564: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6565: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6566: WHERE qpil.request_id = p_request_id
6567: AND qpip.request_id = p_request_id -- bug no 5881528
6568: AND qpil.process_status_flag ='P' --is null
6569: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

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

Line 6602: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6598: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6599: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6600: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6601: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6602: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6603: WHERE qpil.request_id = p_request_id
6604: AND qpip.request_id = p_request_id -- bug no 5881528
6605: AND qpil.process_status_flag ='P' --is null
6606: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

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

Line 6635: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6631: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6632: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6633: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6634: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6635: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6636: WHERE qpil.request_id = p_request_id
6637: AND qpip.request_id = p_request_id -- bug no 5881528
6638: AND qpil.process_status_flag ='P' --is null
6639: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

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

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

Line 6667: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip

6663: FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_LOGIN_ID, qpil.request_id, 661,
6664: NULL,NULL, 'PRL', 'QP_INTERFACE_LIST_LINES', 'PRODUCT_ATTRIBUTE',
6665: qpip.orig_sys_header_ref,qpip.orig_sys_line_ref,null,
6666: qpip.orig_sys_pricing_attr_ref, l_msg_txt
6667: FROM QP_INTERFACE_LIST_LINES qpil, QP_INTERFACE_PRICING_ATTRIBS qpip
6668: WHERE qpil.request_id = p_request_id
6669: AND qpip.request_id = p_request_id -- bug no 5881528
6670: AND qpil.process_status_flag ='P' --is null
6671: AND qpil.orig_sys_line_ref = qpip.orig_sys_line_ref

Line 6733: UPDATE qp_interface_list_lines l

6729: AND e.request_id = p_request_id);
6730:
6731: ELSIF p_table_type = 'LINE' THEN
6732:
6733: UPDATE qp_interface_list_lines l
6734: SET process_status_flag = NULL --'E'
6735: WHERE l.request_id =p_request_id
6736: AND EXISTS
6737: (SELECT orig_sys_line_ref

Line 6741: AND table_name ='QP_INTERFACE_LIST_LINES'

6737: (SELECT orig_sys_line_ref
6738: FROM qp_interface_errors e
6739: WHERE e.orig_sys_line_ref = l.orig_sys_line_ref
6740: AND e.orig_sys_header_ref = l.orig_sys_header_ref
6741: AND table_name ='QP_INTERFACE_LIST_LINES'
6742: AND e.request_id = p_request_id );
6743:
6744: ELSIF p_table_type = 'PRICING_ATTRIBS' THEN
6745: