APPS.QP_UTIL_PUB dependencies on QP_LIMIT_BALANCES

Line 6: Utility procedure to update the qp_limit_balances table as an autonomous

2: /* $Header: QPXRTCNB.pls 120.19.12020000.3 2012/12/19 07:24:38 smbalara ship $ */
3:
4: l_debug VARCHAR2(3);
5: /************************************************************************
6: Utility procedure to update the qp_limit_balances table as an autonomous
7: transaction. This procedure is called by the Reverse_Limits procedure below.
8: *************************************************************************/
9:
10: PROCEDURE Update_Balance(p_new_trxn_amount IN NUMBER,

Line 21: UPDATE qp_limit_balances

17: IF l_debug = Fnd_Api.G_TRUE THEN
18: Qp_Preq_Grp.engine_debug('***Begin Update_Balance***');
19:
20: END IF;
21: UPDATE qp_limit_balances
22: SET available_amount = available_amount - p_new_trxn_amount +
23: p_old_trxn_amount,
24: last_update_date = SYSDATE,
25: last_updated_by = Fnd_Global.user_id

Line 269: from qp_limits ql, qp_limit_balances qlb

265: --Transaction Record to be cancelled/amended exists. Update trxn amount.
266: --bug 13521835
267: BEGIN
268: select ql.BASIS into l_basis
269: from qp_limits ql, qp_limit_balances qlb
270: where ql.list_header_id = l_cons_trans_rec.list_header_id
271: and ql.list_line_id = l_cons_trans_rec.list_line_id
272: and ql.limit_id = qlb.limit_id
273: and qlb.limit_balance_id = l_cons_trans_rec.limit_balance_id;

Line 319: from qp_limits ql, qp_limit_balances qlb

315: WHEN NO_DATA_FOUND THEN
316: --bug13521835
317: BEGIN
318: select ql.BASIS into l_basis
319: from qp_limits ql, qp_limit_balances qlb
320: where ql.list_header_id = l_cons_trans_rec.list_header_id
321: and ql.list_line_id = l_cons_trans_rec.list_line_id
322: and ql.limit_id = qlb.limit_id
323: and qlb.limit_balance_id = l_cons_trans_rec.limit_balance_id;

Line 400: from qp_limits ql, qp_limit_balances qlb

396: qp_Preq_Grp.engine_debug('l_consumed_amount :'||l_consumed_amount);
397: --bug13521835
398: BEGIN
399: select ql.BASIS into l_basis
400: from qp_limits ql, qp_limit_balances qlb
401: where ql.list_header_id = l_cons_trans_rec.list_header_id
402: and ql.list_line_id = l_cons_trans_rec.list_line_id
403: and ql.limit_id = qlb.limit_id
404: and qlb.limit_balance_id = l_cons_trans_rec.limit_balance_id;