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.9.12010000.5 2008/11/25 23:40:11 rbadadar 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