DBA Data[Home] [Help]

APPS.CN_PAYMENT_WORKSHEETS_PKG dependencies on FND_GLOBAL

Line 423: last_updated_by = fnd_global.user_id,

419: pmt_amount_adj_rec = NVL (pmt_amount_adj_rec, 0) + NVL (p_pmt_amount_adj_rec, 0),
420: pmt_amount_adj = NVL (pmt_amount_adj, 0) + NVL (p_pmt_amount_adj, 0),
421: pmt_amount_calc = NVL (pmt_amount_calc, 0) + NVL (p_pmt_amount_calc, 0),
422: pmt_amount_recovery = NVL (pmt_amount_recovery, 0) + NVL (p_pmt_amount_recovery, 0),
423: last_updated_by = fnd_global.user_id,
424: last_update_date = SYSDATE,
425: last_update_login = fnd_global.login_id,
426: object_version_number = x_object_version_number
427: WHERE salesrep_id = p_salesrep_id

Line 425: last_update_login = fnd_global.login_id,

421: pmt_amount_calc = NVL (pmt_amount_calc, 0) + NVL (p_pmt_amount_calc, 0),
422: pmt_amount_recovery = NVL (pmt_amount_recovery, 0) + NVL (p_pmt_amount_recovery, 0),
423: last_updated_by = fnd_global.user_id,
424: last_update_date = SYSDATE,
425: last_update_login = fnd_global.login_id,
426: object_version_number = x_object_version_number
427: WHERE salesrep_id = p_salesrep_id
428: AND payrun_id = p_payrun_id
429: AND (quota_id = p_quota_id OR quota_id IS NULL);

Line 447: last_updated_by = fnd_global.user_id,

443: BEGIN
444:
445: UPDATE cn_payment_worksheets
446: SET worksheet_status = p_worksheet_status,
447: last_updated_by = fnd_global.user_id,
448: last_update_date = SYSDATE,
449: last_update_login = fnd_global.login_id,
450: object_version_number = nvl(object_version_number,0) + 1
451: WHERE salesrep_id = p_salesrep_id

Line 449: last_update_login = fnd_global.login_id,

445: UPDATE cn_payment_worksheets
446: SET worksheet_status = p_worksheet_status,
447: last_updated_by = fnd_global.user_id,
448: last_update_date = SYSDATE,
449: last_update_login = fnd_global.login_id,
450: object_version_number = nvl(object_version_number,0) + 1
451: WHERE salesrep_id = p_salesrep_id
452: AND payrun_id = p_payrun_id;
453: