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
26: WHERE limit_balance_id = p_limit_balance_id;
27:
28: COMMIT;
29:
201: )
202: VALUES
203: (l_cons_trans_rec.limit_balance_id,
204: SYSDATE,
205: Fnd_Global.user_id,
206: SYSDATE,
207: Fnd_Global.user_id,
208: l_cons_trans_rec.list_header_id,
209: l_cons_trans_rec.list_line_id,
203: (l_cons_trans_rec.limit_balance_id,
204: SYSDATE,
205: Fnd_Global.user_id,
206: SYSDATE,
207: Fnd_Global.user_id,
208: l_cons_trans_rec.list_header_id,
209: l_cons_trans_rec.list_line_id,
210: SYSDATE,
211: l_cons_trans_rec.price_request_type_code,
228: --Return Transaction Record exists. Update trxn amount
229: UPDATE qp_limit_transactions
230: SET amount = (l_proration * l_cons_trans_rec.amount),
231: last_update_date = SYSDATE,
232: last_updated_by = Fnd_Global.user_id
233: WHERE price_request_code = p_ret_price_request_code
234: AND list_header_id = l_cons_trans_rec.list_header_id
235: AND list_line_id = l_cons_trans_rec.list_line_id
236: AND limit_balance_id = l_cons_trans_rec.limit_balance_id;
262: --Transaction Record to be cancelled/amended exists. Update trxn amount.
263: UPDATE qp_limit_transactions
264: SET amount = (l_proration * l_cons_trans_rec.amount),
265: last_update_date = SYSDATE,
266: last_updated_by = Fnd_Global.user_id
267: WHERE price_request_code = p_cons_price_request_code
268: AND list_header_id = l_cons_trans_rec.list_header_id
269: AND list_line_id = l_cons_trans_rec.list_line_id
270: AND limit_balance_id = l_cons_trans_rec.limit_balance_id;
306: )
307: VALUES
308: (l_cons_trans_rec.limit_balance_id,
309: sysdate,
310: fnd_global.user_id,
311: sysdate,
312: fnd_global.user_id,
313: l_cons_trans_rec.list_header_id,
314: l_cons_trans_rec.list_line_id,
308: (l_cons_trans_rec.limit_balance_id,
309: sysdate,
310: fnd_global.user_id,
311: sysdate,
312: fnd_global.user_id,
313: l_cons_trans_rec.list_header_id,
314: l_cons_trans_rec.list_line_id,
315: sysdate,
316: l_cons_trans_rec.price_request_type_code,
351: --Transaction Record to be updated exists. Update trxn amount.
352: UPDATE qp_limit_transactions
353: SET amount = (l_proration * l_cons_trans_rec.amount),
354: last_update_date = sysdate,
355: last_updated_by = fnd_global.user_id
356: WHERE price_request_code = p_cons_price_request_code
357: AND list_header_id = l_cons_trans_rec.list_header_id
358: AND list_line_id = l_cons_trans_rec.list_line_id
359: AND limit_balance_id = l_cons_trans_rec.limit_balance_id;
2916: l_context_name VARCHAR2(60);
2917: l_attr_def_condition_id VARCHAR2(60);
2918:
2919:
2920: G_USER_ID NUMBER := Fnd_Global.USER_ID;
2921: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;
2922:
2923: BEGIN
2924:
2917: l_attr_def_condition_id VARCHAR2(60);
2918:
2919:
2920: G_USER_ID NUMBER := Fnd_Global.USER_ID;
2921: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;
2922:
2923: BEGIN
2924:
2925: