DBA Data[Home] [Help]

APPS.IBY_EXT_BANKACCT_PUB dependencies on FND_GLOBAL

Line 1561: fnd_global.user_id, --CREATED_BY,

1557: --PROGRAM_ID,
1558: --PROGRAM_UPDATE_DATE,
1559: NVL(p_ext_bank_acct_rec.start_date, sysdate), --START_DATE,
1560: p_ext_bank_acct_rec.end_date, --END_DATE,
1561: fnd_global.user_id, --CREATED_BY,
1562: sysdate, --CREATION_DATE,
1563: fnd_global.user_id, --LAST_UPDATED_BY,
1564: sysdate, --LAST_UPDATE_DATE,
1565: fnd_global.login_id, --LAST_UPDATE_LOGIN,

Line 1563: fnd_global.user_id, --LAST_UPDATED_BY,

1559: NVL(p_ext_bank_acct_rec.start_date, sysdate), --START_DATE,
1560: p_ext_bank_acct_rec.end_date, --END_DATE,
1561: fnd_global.user_id, --CREATED_BY,
1562: sysdate, --CREATION_DATE,
1563: fnd_global.user_id, --LAST_UPDATED_BY,
1564: sysdate, --LAST_UPDATE_DATE,
1565: fnd_global.login_id, --LAST_UPDATE_LOGIN,
1566: 1.0, --OBJECT_VERSION_NUMBER,
1567: p_ext_bank_acct_rec.bank_account_name, --BANK_ACCOUNT_NAME

Line 1565: fnd_global.login_id, --LAST_UPDATE_LOGIN,

1561: fnd_global.user_id, --CREATED_BY,
1562: sysdate, --CREATION_DATE,
1563: fnd_global.user_id, --LAST_UPDATED_BY,
1564: sysdate, --LAST_UPDATE_DATE,
1565: fnd_global.login_id, --LAST_UPDATE_LOGIN,
1566: 1.0, --OBJECT_VERSION_NUMBER,
1567: p_ext_bank_acct_rec.bank_account_name, --BANK_ACCOUNT_NAME
1568: p_ext_bank_acct_rec.alternate_acct_name, --BANK_ACCOUNT_NAME_ALT
1569: p_ext_bank_acct_rec.short_acct_name, --SHORT_ACCT_NAME

Line 2413: LAST_UPDATED_BY = fnd_global.user_id,

2409: ATTRIBUTE12 = p_ext_bank_acct_rec.attribute12,
2410: ATTRIBUTE13 = p_ext_bank_acct_rec.attribute13,
2411: ATTRIBUTE14 = p_ext_bank_acct_rec.attribute14,
2412: ATTRIBUTE15 = p_ext_bank_acct_rec.attribute15,
2413: LAST_UPDATED_BY = fnd_global.user_id,
2414: LAST_UPDATE_DATE = sysdate,
2415: LAST_UPDATE_LOGIN = fnd_global.login_id,
2416: BANK_ACCOUNT_NAME = p_ext_bank_acct_rec.bank_account_name,
2417: BANK_ACCOUNT_NAME_ALT = p_ext_bank_acct_rec.alternate_acct_name,

Line 2415: LAST_UPDATE_LOGIN = fnd_global.login_id,

2411: ATTRIBUTE14 = p_ext_bank_acct_rec.attribute14,
2412: ATTRIBUTE15 = p_ext_bank_acct_rec.attribute15,
2413: LAST_UPDATED_BY = fnd_global.user_id,
2414: LAST_UPDATE_DATE = sysdate,
2415: LAST_UPDATE_LOGIN = fnd_global.login_id,
2416: BANK_ACCOUNT_NAME = p_ext_bank_acct_rec.bank_account_name,
2417: BANK_ACCOUNT_NAME_ALT = p_ext_bank_acct_rec.alternate_acct_name,
2418: SHORT_ACCT_NAME = p_ext_bank_acct_rec.short_acct_name,
2419: DESCRIPTION = p_ext_bank_acct_rec.description,

Line 3273: NVL(FND_GLOBAL.user_id,-1),

3269: OBJECT_VERSION_NUMBER)
3270: VALUES (
3271: IBY_INTERMEDIARY_ACCTS_S.nextval,
3272: sysdate,
3273: NVL(FND_GLOBAL.user_id,-1),
3274: NVL(FND_GLOBAL.login_id, -1),
3275: sysdate,
3276: NVL(FND_GLOBAL.user_id,-1),
3277: p_intermed_acct_rec.bank_account_id,

Line 3274: NVL(FND_GLOBAL.login_id, -1),

3270: VALUES (
3271: IBY_INTERMEDIARY_ACCTS_S.nextval,
3272: sysdate,
3273: NVL(FND_GLOBAL.user_id,-1),
3274: NVL(FND_GLOBAL.login_id, -1),
3275: sysdate,
3276: NVL(FND_GLOBAL.user_id,-1),
3277: p_intermed_acct_rec.bank_account_id,
3278: p_intermed_acct_rec.country_code,

Line 3276: NVL(FND_GLOBAL.user_id,-1),

3272: sysdate,
3273: NVL(FND_GLOBAL.user_id,-1),
3274: NVL(FND_GLOBAL.login_id, -1),
3275: sysdate,
3276: NVL(FND_GLOBAL.user_id,-1),
3277: p_intermed_acct_rec.bank_account_id,
3278: p_intermed_acct_rec.country_code,
3279: p_intermed_acct_rec.bank_name,
3280: p_intermed_acct_rec.city,

Line 3424: last_update_login = NVL(FND_GLOBAL.login_id,-1),

3420: check_digits = p_intermed_acct_rec.check_digits,
3421: iban = p_intermed_acct_rec.iban,
3422: comments = p_intermed_acct_rec.comments,
3423: last_update_date = sysdate,
3424: last_update_login = NVL(FND_GLOBAL.login_id,-1),
3425: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3426: object_version_number = l_old_ovn + 1
3427: WHERE intermediary_acct_id = p_intermed_acct_rec.intermediary_acct_id
3428: RETURNING object_version_number INTO p_intermed_acct_rec.object_version_number;

Line 3425: last_updated_by = NVL(FND_GLOBAL.user_id,-1),

3421: iban = p_intermed_acct_rec.iban,
3422: comments = p_intermed_acct_rec.comments,
3423: last_update_date = sysdate,
3424: last_update_login = NVL(FND_GLOBAL.login_id,-1),
3425: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3426: object_version_number = l_old_ovn + 1
3427: WHERE intermediary_acct_id = p_intermed_acct_rec.intermediary_acct_id
3428: RETURNING object_version_number INTO p_intermed_acct_rec.object_version_number;
3429:

Line 3571: fnd_global.user_id,

3567: p_bank_account_id,
3568: p_acct_owner_party_id,
3569: NULL,
3570: 'N',
3571: fnd_global.user_id,
3572: sysdate,
3573: fnd_global.user_id,
3574: sysdate,
3575: fnd_global.user_id,

Line 3573: fnd_global.user_id,

3569: NULL,
3570: 'N',
3571: fnd_global.user_id,
3572: sysdate,
3573: fnd_global.user_id,
3574: sysdate,
3575: fnd_global.user_id,
3576: 1.0
3577: ) RETURNING ACCOUNT_OWNER_ID INTO x_joint_acct_owner_id;

Line 3575: fnd_global.user_id,

3571: fnd_global.user_id,
3572: sysdate,
3573: fnd_global.user_id,
3574: sysdate,
3575: fnd_global.user_id,
3576: 1.0
3577: ) RETURNING ACCOUNT_OWNER_ID INTO x_joint_acct_owner_id;
3578:
3579: -- get message count and if count is 1, get message info.

Line 4400: last_updated_by = fnd_global.user_id,

4396: 'Y'
4397: ),
4398: object_version_number = object_version_number + 1,
4399: last_update_date = sysdate,
4400: last_updated_by = fnd_global.user_id,
4401: last_update_login = fnd_global.login_id
4402: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
4403:
4404: END LOOP;

Line 4401: last_update_login = fnd_global.login_id

4397: ),
4398: object_version_number = object_version_number + 1,
4399: last_update_date = sysdate,
4400: last_updated_by = fnd_global.user_id,
4401: last_update_login = fnd_global.login_id
4402: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
4403:
4404: END LOOP;
4405:

Line 4653: last_updated_by = fnd_global.user_id,

4649: ba_num_elec_sec_segment_id = NULL,
4650: encrypted = 'N',
4651: object_version_number = object_version_number + 1,
4652: last_update_date = sysdate,
4653: last_updated_by = fnd_global.user_id,
4654: last_update_login = fnd_global.login_id
4655: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
4656:
4657: DELETE FROM iby_security_segments

Line 4654: last_update_login = fnd_global.login_id

4650: encrypted = 'N',
4651: object_version_number = object_version_number + 1,
4652: last_update_date = sysdate,
4653: last_updated_by = fnd_global.user_id,
4654: last_update_login = fnd_global.login_id
4655: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
4656:
4657: DELETE FROM iby_security_segments
4658: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;