APPS.QP_UTIL_PUB dependencies on QP_LIMIT_TRANSACTIONS

Line 56: FROM qp_limit_transactions

52: IS
53: SELECT limit_balance_id, list_header_id, list_line_id,
54: price_request_type_code, price_request_code,
55: pricing_phase_id, amount
56: FROM qp_limit_transactions
57: WHERE price_request_code = a_cons_price_request_code;
58:
59: l_proration NUMBER;
60: l_returned_amount NUMBER;

Line 181: FROM qp_limit_transactions

177: BEGIN
178: --Check if a return record exists.
179: SELECT amount
180: INTO l_returned_amount
181: FROM qp_limit_transactions
182: WHERE price_request_code = p_ret_price_request_code
183: AND list_header_id = l_cons_trans_rec.list_header_id
184: AND list_line_id = l_cons_trans_rec.list_line_id
185: AND limit_balance_id = l_cons_trans_rec.limit_balance_id;

Line 191: INSERT INTO qp_limit_transactions

187: EXCEPTION
188: WHEN NO_DATA_FOUND THEN
189:
190: --Record does not already exist,insert a new return trxn record
191: INSERT INTO qp_limit_transactions
192: (limit_balance_id,
193: creation_date,
194: created_by,
195: last_update_date,

Line 232: UPDATE qp_limit_transactions

228:
229: END; --Block around SELECT stmt to check if returned rec exists
230:
231: --Return Transaction Record exists. Update trxn amount
232: UPDATE qp_limit_transactions
233: SET amount = (l_proration * l_cons_trans_rec.amount),
234: last_update_date = SYSDATE,
235: last_updated_by = Fnd_Global.user_id,
236: price_request_date = SYSDATE --bug#12715755

Line 253: FROM qp_limit_transactions

249: BEGIN
250: --A record must exist for it to be cancelled or amended.
251: SELECT amount
252: INTO l_consumed_amount
253: FROM qp_limit_transactions
254: WHERE price_request_code = p_cons_price_request_code
255: AND list_header_id = l_cons_trans_rec.list_header_id
256: AND list_line_id = l_cons_trans_rec.list_line_id
257: AND limit_balance_id = l_cons_trans_rec.limit_balance_id;

Line 285: UPDATE qp_limit_transactions

281: END;
282: --bug 13521835
283:
284: --Transaction Record to be cancelled/amended exists. Update trxn amount.
285: UPDATE qp_limit_transactions
286: SET amount = amount_rounded, --bug 13521835
287: last_update_date = SYSDATE,
288: last_updated_by = Fnd_Global.user_id,
289: price_request_date = sysdate --bug#12715755

Line 308: FROM qp_limit_transactions

304: BEGIN
305: --Check if a split child record exists.
306: SELECT amount
307: INTO l_returned_amount
308: FROM qp_limit_transactions
309: WHERE price_request_code = p_ret_price_request_code
310: AND list_header_id = l_cons_trans_rec.list_header_id
311: AND list_line_id = l_cons_trans_rec.list_line_id
312: AND limit_balance_id = l_cons_trans_rec.limit_balance_id;

Line 337: INSERT INTO qp_limit_transactions

333: END;
334: --bug13521835
335:
336: --Record does not already exist,insert a new return trxn record
337: INSERT INTO qp_limit_transactions
338: (limit_balance_id,
339: creation_date,
340: created_by,
341: last_update_date,

Line 384: FROM qp_limit_transactions

380: BEGIN
381: --A record must exist for it to updated.
382: SELECT amount
383: INTO l_consumed_amount
384: FROM qp_limit_transactions
385: WHERE price_request_code = p_cons_price_request_code
386: AND list_header_id = l_cons_trans_rec.list_header_id
387: AND list_line_id = l_cons_trans_rec.list_line_id
388: AND limit_balance_id = l_cons_trans_rec.limit_balance_id;

Line 417: UPDATE qp_limit_transactions

413: qp_Preq_Grp.engine_debug('l_basis :'||l_basis);
414: qp_Preq_Grp.engine_debug('amount_rounded :'||amount_rounded);
415: --bug13521835
416: --Transaction Record to be updated exists. Update trxn amount.
417: UPDATE qp_limit_transactions
418: SET amount = amount_rounded, --bug13521835
419: last_update_date = sysdate,
420: last_updated_by = fnd_global.user_id,
421: price_request_date = sysdate --bug#12715755