eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IBY_EXT_BANKACCT_PUB dependencies on FND_GLOBAL

Line 1786: fnd_global.user_id, --CREATED_BY,

1782: --PROGRAM_ID,
1783: --PROGRAM_UPDATE_DATE,
1784: trunc(NVL(p_ext_bank_acct_rec.start_date, sysdate)), --START_DATE,
1785: trunc(p_ext_bank_acct_rec.end_date), --END_DATE,
1786: fnd_global.user_id, --CREATED_BY,
1787: sysdate, --CREATION_DATE,
1788: fnd_global.user_id, --LAST_UPDATED_BY,
1789: sysdate, --LAST_UPDATE_DATE,
1790: fnd_global.login_id, --LAST_UPDATE_LOGIN,

Line 1788: fnd_global.user_id, --LAST_UPDATED_BY,

1784: trunc(NVL(p_ext_bank_acct_rec.start_date, sysdate)), --START_DATE,
1785: trunc(p_ext_bank_acct_rec.end_date), --END_DATE,
1786: fnd_global.user_id, --CREATED_BY,
1787: sysdate, --CREATION_DATE,
1788: fnd_global.user_id, --LAST_UPDATED_BY,
1789: sysdate, --LAST_UPDATE_DATE,
1790: fnd_global.login_id, --LAST_UPDATE_LOGIN,
1791: 1.0, --OBJECT_VERSION_NUMBER,
1792: p_ext_bank_acct_rec.bank_account_name, --BANK_ACCOUNT_NAME

Line 1790: fnd_global.login_id, --LAST_UPDATE_LOGIN,

1786: fnd_global.user_id, --CREATED_BY,
1787: sysdate, --CREATION_DATE,
1788: fnd_global.user_id, --LAST_UPDATED_BY,
1789: sysdate, --LAST_UPDATE_DATE,
1790: fnd_global.login_id, --LAST_UPDATE_LOGIN,
1791: 1.0, --OBJECT_VERSION_NUMBER,
1792: p_ext_bank_acct_rec.bank_account_name, --BANK_ACCOUNT_NAME
1793: p_ext_bank_acct_rec.alternate_acct_name, --BANK_ACCOUNT_NAME_ALT
1794: p_ext_bank_acct_rec.short_acct_name, --SHORT_ACCT_NAME

Line 2974: LAST_UPDATED_BY = fnd_global.user_id,

2970: ATTRIBUTE12 = p_ext_bank_acct_rec.attribute12,
2971: ATTRIBUTE13 = p_ext_bank_acct_rec.attribute13,
2972: ATTRIBUTE14 = p_ext_bank_acct_rec.attribute14,
2973: ATTRIBUTE15 = p_ext_bank_acct_rec.attribute15,
2974: LAST_UPDATED_BY = fnd_global.user_id,
2975: LAST_UPDATE_DATE = sysdate,
2976: LAST_UPDATE_LOGIN = fnd_global.login_id,
2977: BANK_ACCOUNT_NAME = p_ext_bank_acct_rec.bank_account_name,
2978: BANK_ACCOUNT_NAME_ALT = p_ext_bank_acct_rec.alternate_acct_name,

Line 2976: LAST_UPDATE_LOGIN = fnd_global.login_id,

2972: ATTRIBUTE14 = p_ext_bank_acct_rec.attribute14,
2973: ATTRIBUTE15 = p_ext_bank_acct_rec.attribute15,
2974: LAST_UPDATED_BY = fnd_global.user_id,
2975: LAST_UPDATE_DATE = sysdate,
2976: LAST_UPDATE_LOGIN = fnd_global.login_id,
2977: BANK_ACCOUNT_NAME = p_ext_bank_acct_rec.bank_account_name,
2978: BANK_ACCOUNT_NAME_ALT = p_ext_bank_acct_rec.alternate_acct_name,
2979: SHORT_ACCT_NAME = p_ext_bank_acct_rec.short_acct_name,
2980: DESCRIPTION =p_ext_bank_acct_rec.description,

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

3909: OBJECT_VERSION_NUMBER)
3910: VALUES (
3911: IBY_INTERMEDIARY_ACCTS_S.nextval,
3912: sysdate,
3913: NVL(FND_GLOBAL.user_id,-1),
3914: NVL(FND_GLOBAL.login_id, -1),
3915: sysdate,
3916: NVL(FND_GLOBAL.user_id,-1),
3917: p_intermed_acct_rec.bank_account_id,

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

3910: VALUES (
3911: IBY_INTERMEDIARY_ACCTS_S.nextval,
3912: sysdate,
3913: NVL(FND_GLOBAL.user_id,-1),
3914: NVL(FND_GLOBAL.login_id, -1),
3915: sysdate,
3916: NVL(FND_GLOBAL.user_id,-1),
3917: p_intermed_acct_rec.bank_account_id,
3918: -99,

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

3912: sysdate,
3913: NVL(FND_GLOBAL.user_id,-1),
3914: NVL(FND_GLOBAL.login_id, -1),
3915: sysdate,
3916: NVL(FND_GLOBAL.user_id,-1),
3917: p_intermed_acct_rec.bank_account_id,
3918: -99,
3919: p_intermed_acct_rec.country_code,
3920: p_intermed_acct_rec.bank_name,

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

4067: check_digits = p_intermed_acct_rec.check_digits,
4068: iban = p_intermed_acct_rec.iban,
4069: comments = p_intermed_acct_rec.comments,
4070: last_update_date = sysdate,
4071: last_update_login = NVL(FND_GLOBAL.login_id,-1),
4072: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
4073: object_version_number = l_old_ovn + 1
4074: WHERE intermediary_acct_id = p_intermed_acct_rec.intermediary_acct_id
4075: RETURNING object_version_number INTO p_intermed_acct_rec.object_version_number;

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

4068: iban = p_intermed_acct_rec.iban,
4069: comments = p_intermed_acct_rec.comments,
4070: last_update_date = sysdate,
4071: last_update_login = NVL(FND_GLOBAL.login_id,-1),
4072: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
4073: object_version_number = l_old_ovn + 1
4074: WHERE intermediary_acct_id = p_intermed_acct_rec.intermediary_acct_id
4075: RETURNING object_version_number INTO p_intermed_acct_rec.object_version_number;
4076:

Line 4243: fnd_global.user_id,

4239: p_bank_account_id,
4240: p_acct_owner_party_id,
4241: NULL,
4242: l_primary_flag,
4243: fnd_global.user_id,
4244: sysdate,
4245: fnd_global.user_id,
4246: sysdate,
4247: fnd_global.user_id,

Line 4245: fnd_global.user_id,

4241: NULL,
4242: l_primary_flag,
4243: fnd_global.user_id,
4244: sysdate,
4245: fnd_global.user_id,
4246: sysdate,
4247: fnd_global.user_id,
4248: 1.0
4249: ) RETURNING ACCOUNT_OWNER_ID INTO x_joint_acct_owner_id;

Line 4247: fnd_global.user_id,

4243: fnd_global.user_id,
4244: sysdate,
4245: fnd_global.user_id,
4246: sysdate,
4247: fnd_global.user_id,
4248: 1.0
4249: ) RETURNING ACCOUNT_OWNER_ID INTO x_joint_acct_owner_id;
4250:
4251: -- get message count and if count is 1, get message info.

Line 5238: last_updated_by = fnd_global.user_id,

5234: 'Y'
5235: ),
5236: object_version_number = object_version_number + 1,
5237: last_update_date = sysdate,
5238: last_updated_by = fnd_global.user_id,
5239: last_update_login = fnd_global.login_id
5240: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
5241:
5242: END LOOP;

Line 5239: last_update_login = fnd_global.login_id

5235: ),
5236: object_version_number = object_version_number + 1,
5237: last_update_date = sysdate,
5238: last_updated_by = fnd_global.user_id,
5239: last_update_login = fnd_global.login_id
5240: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
5241:
5242: END LOOP;
5243:

Line 5491: last_updated_by = fnd_global.user_id,

5487: ba_num_elec_sec_segment_id = NULL,
5488: encrypted = 'N',
5489: object_version_number = object_version_number + 1,
5490: last_update_date = sysdate,
5491: last_updated_by = fnd_global.user_id,
5492: last_update_login = fnd_global.login_id
5493: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
5494:
5495: DELETE FROM iby_security_segments

Line 5492: last_update_login = fnd_global.login_id

5488: encrypted = 'N',
5489: object_version_number = object_version_number + 1,
5490: last_update_date = sysdate,
5491: last_updated_by = fnd_global.user_id,
5492: last_update_login = fnd_global.login_id
5493: WHERE (ext_bank_account_id = ext_ba_rec.ext_bank_account_id);
5494:
5495: DELETE FROM iby_security_segments
5496: WHERE sec_segment_id = ext_ba_rec.ba_num_sec_segment_id;