APPS.CN_PMT_TRANS_PKG dependencies on FND_GLOBAL

Line 5: g_last_updated_by NUMBER := fnd_global.user_id;

1: PACKAGE BODY cn_pmt_trans_pkg AS
2: -- $Header: cntpmtrb.pls 120.9.12000000.2 2007/06/08 21:22:10 fmburu ship $ --+
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_PMT_TRANS_PKG';
4: --G_LAST_UPDATE_DATE DATE := SYSDATE;
5: g_last_updated_by NUMBER := fnd_global.user_id;
6: --G_CREATION_DATE DATE := SYSDATE;
7: g_created_by NUMBER := fnd_global.user_id;
8: g_last_update_login NUMBER := fnd_global.login_id;
9: --Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04

Line 7: g_created_by NUMBER := fnd_global.user_id;

3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_PMT_TRANS_PKG';
4: --G_LAST_UPDATE_DATE DATE := SYSDATE;
5: g_last_updated_by NUMBER := fnd_global.user_id;
6: --G_CREATION_DATE DATE := SYSDATE;
7: g_created_by NUMBER := fnd_global.user_id;
8: g_last_update_login NUMBER := fnd_global.login_id;
9: --Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04
10: g_payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE;
11:

Line 8: g_last_update_login NUMBER := fnd_global.login_id;

4: --G_LAST_UPDATE_DATE DATE := SYSDATE;
5: g_last_updated_by NUMBER := fnd_global.user_id;
6: --G_CREATION_DATE DATE := SYSDATE;
7: g_created_by NUMBER := fnd_global.user_id;
8: g_last_update_login NUMBER := fnd_global.login_id;
9: --Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04
10: g_payment_transaction_id cn_payment_transactions.payment_transaction_id%TYPE;
11:
12: --==============================================================================

Line 161: fnd_global.user_id,

157: DECODE (p_tran_rec.attribute13, fnd_api.g_miss_char, NULL, p_tran_rec.attribute13),
158: DECODE (p_tran_rec.attribute14, fnd_api.g_miss_char, NULL, p_tran_rec.attribute14),
159: DECODE (p_tran_rec.attribute15, fnd_api.g_miss_char, NULL, p_tran_rec.attribute15),
160: SYSDATE,
161: fnd_global.user_id,
162: fnd_global.login_id,
163: SYSDATE,
164: fnd_global.user_id,
165: p_tran_rec.org_id,

Line 162: fnd_global.login_id,

158: DECODE (p_tran_rec.attribute14, fnd_api.g_miss_char, NULL, p_tran_rec.attribute14),
159: DECODE (p_tran_rec.attribute15, fnd_api.g_miss_char, NULL, p_tran_rec.attribute15),
160: SYSDATE,
161: fnd_global.user_id,
162: fnd_global.login_id,
163: SYSDATE,
164: fnd_global.user_id,
165: p_tran_rec.org_id,
166: nvl(p_tran_rec.object_version_number,1)

Line 164: fnd_global.user_id,

160: SYSDATE,
161: fnd_global.user_id,
162: fnd_global.login_id,
163: SYSDATE,
164: fnd_global.user_id,
165: p_tran_rec.org_id,
166: nvl(p_tran_rec.object_version_number,1)
167: FROM DUAL);
168: END INSERT_RECORD;

Line 535: fnd_global.user_id,

531: p_payrun_id,
532: NVL (cl.commission_amount, 0),
533: DECODE (l_payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id,
534: SYSDATE,
535: fnd_global.user_id,
536: SYSDATE,
537: g_last_updated_by,
538: g_last_update_login,
539: cl.org_id,

Line 643: fnd_global.user_id,

639: NVL (cl.commission_amount, 0),
640: -- Bug 2875120 : remove cn_api function call in sql statement
641: DECODE (l_payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id,
642: SYSDATE,
643: fnd_global.user_id,
644: SYSDATE,
645: --Bug 3080846 for who columns
646: g_last_updated_by,
647: g_last_update_login,