DBA Data[Home] [Help]

APPS.QP_UTIL_PUB dependencies on FND_GLOBAL

Line 25: last_updated_by = Fnd_Global.user_id

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:

Line 205: Fnd_Global.user_id,

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,

Line 207: Fnd_Global.user_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,

Line 232: last_updated_by = Fnd_Global.user_id

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;

Line 266: last_updated_by = Fnd_Global.user_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;

Line 310: fnd_global.user_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,

Line 312: fnd_global.user_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,

Line 355: last_updated_by = fnd_global.user_id

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;

Line 2920: G_USER_ID NUMBER := Fnd_Global.USER_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:

Line 2921: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;

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: