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 208: Fnd_Global.user_id,

204: )
205: VALUES
206: (l_cons_trans_rec.limit_balance_id,
207: SYSDATE,
208: Fnd_Global.user_id,
209: SYSDATE,
210: Fnd_Global.user_id,
211: l_cons_trans_rec.list_header_id,
212: l_cons_trans_rec.list_line_id,

Line 210: Fnd_Global.user_id,

206: (l_cons_trans_rec.limit_balance_id,
207: SYSDATE,
208: Fnd_Global.user_id,
209: SYSDATE,
210: Fnd_Global.user_id,
211: l_cons_trans_rec.list_header_id,
212: l_cons_trans_rec.list_line_id,
213: SYSDATE,
214: l_cons_trans_rec.price_request_type_code,

Line 235: last_updated_by = Fnd_Global.user_id,

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
237: WHERE price_request_code = p_ret_price_request_code
238: AND list_header_id = l_cons_trans_rec.list_header_id
239: AND list_line_id = l_cons_trans_rec.list_line_id

Line 288: last_updated_by = Fnd_Global.user_id,

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
290: WHERE price_request_code = p_cons_price_request_code
291: AND list_header_id = l_cons_trans_rec.list_header_id
292: AND list_line_id = l_cons_trans_rec.list_line_id

Line 354: fnd_global.user_id,

350: )
351: VALUES
352: (l_cons_trans_rec.limit_balance_id,
353: sysdate,
354: fnd_global.user_id,
355: sysdate,
356: fnd_global.user_id,
357: l_cons_trans_rec.list_header_id,
358: l_cons_trans_rec.list_line_id,

Line 356: fnd_global.user_id,

352: (l_cons_trans_rec.limit_balance_id,
353: sysdate,
354: fnd_global.user_id,
355: sysdate,
356: fnd_global.user_id,
357: l_cons_trans_rec.list_header_id,
358: l_cons_trans_rec.list_line_id,
359: sysdate,
360: l_cons_trans_rec.price_request_type_code,

Line 420: last_updated_by = fnd_global.user_id,

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
422: WHERE price_request_code = p_cons_price_request_code
423: AND list_header_id = l_cons_trans_rec.list_header_id
424: AND list_line_id = l_cons_trans_rec.list_line_id

Line 3250: G_USER_ID NUMBER := Fnd_Global.USER_ID;

3246: l_context_name VARCHAR2(60);
3247: l_attr_def_condition_id VARCHAR2(60);
3248:
3249:
3250: G_USER_ID NUMBER := Fnd_Global.USER_ID;
3251: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;
3252:
3253: BEGIN
3254:

Line 3251: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;

3247: l_attr_def_condition_id VARCHAR2(60);
3248:
3249:
3250: G_USER_ID NUMBER := Fnd_Global.USER_ID;
3251: G_LOGIN_ID NUMBER := Fnd_Global.CONC_LOGIN_ID;
3252:
3253: BEGIN
3254:
3255: