DBA Data[Home] [Help]

APPS.CE_BANK_PUB dependencies on FND_GLOBAL

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

2393: p_acct_rec.attribute13,
2394: p_acct_rec.attribute14,
2395: p_acct_rec.attribute15,
2396: sysdate,
2397: NVL(FND_GLOBAL.user_id,-1),
2398: NVL(FND_GLOBAL.login_id, -1),
2399: sysdate,
2400: NVL(FND_GLOBAL.user_id,-1),
2401: 1,

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

2394: p_acct_rec.attribute14,
2395: p_acct_rec.attribute15,
2396: sysdate,
2397: NVL(FND_GLOBAL.user_id,-1),
2398: NVL(FND_GLOBAL.login_id, -1),
2399: sysdate,
2400: NVL(FND_GLOBAL.user_id,-1),
2401: 1,
2402: p_acct_rec.xtr_bank_account_reference);

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

2396: sysdate,
2397: NVL(FND_GLOBAL.user_id,-1),
2398: NVL(FND_GLOBAL.login_id, -1),
2399: sysdate,
2400: NVL(FND_GLOBAL.user_id,-1),
2401: 1,
2402: p_acct_rec.xtr_bank_account_reference);
2403: OPEN c_acct_rowid;
2404: FETCH c_acct_rowid INTO l_acct_rowid;

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

2980: attribute13 = p_acct_rec.attribute13,
2981: attribute14 = p_acct_rec.attribute14,
2982: attribute15 = p_acct_rec.attribute15,
2983: last_update_date = sysdate,
2984: last_update_login = NVL(FND_GLOBAL.login_id,-1),
2985: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2986: object_version_number = l_old_ovn + 1,
2987: xtr_bank_account_reference = p_acct_rec.xtr_bank_account_reference
2988: WHERE bank_account_id = p_acct_rec.bank_account_id;

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

2981: attribute14 = p_acct_rec.attribute14,
2982: attribute15 = p_acct_rec.attribute15,
2983: last_update_date = sysdate,
2984: last_update_login = NVL(FND_GLOBAL.login_id,-1),
2985: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2986: object_version_number = l_old_ovn + 1,
2987: xtr_bank_account_reference = p_acct_rec.xtr_bank_account_reference
2988: WHERE bank_account_id = p_acct_rec.bank_account_id;
2989: IF (SQL%NOTFOUND) THEN

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

3254: p_acct_use_rec.attribute13,
3255: p_acct_use_rec.attribute14,
3256: p_acct_use_rec.attribute15,
3257: sysdate,
3258: NVL(FND_GLOBAL.user_id,-1),
3259: NVL(FND_GLOBAL.login_id, -1),
3260: sysdate,
3261: NVL(FND_GLOBAL.user_id,-1),
3262: 1);

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

3255: p_acct_use_rec.attribute14,
3256: p_acct_use_rec.attribute15,
3257: sysdate,
3258: NVL(FND_GLOBAL.user_id,-1),
3259: NVL(FND_GLOBAL.login_id, -1),
3260: sysdate,
3261: NVL(FND_GLOBAL.user_id,-1),
3262: 1);
3263:

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

3257: sysdate,
3258: NVL(FND_GLOBAL.user_id,-1),
3259: NVL(FND_GLOBAL.login_id, -1),
3260: sysdate,
3261: NVL(FND_GLOBAL.user_id,-1),
3262: 1);
3263:
3264: INSERT INTO CE_GL_ACCOUNTS_CCID (
3265: BANK_ACCT_USE_ID,

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

3317: p_acct_use_rec.bank_interest_income_ccid,
3318: p_acct_use_rec.xtr_asset_ccid,
3319: p_acct_use_rec.ar_bank_charges_ccid, -- 7437641
3320: sysdate,
3321: NVL(FND_GLOBAL.user_id,-1),
3322: NVL(FND_GLOBAL.login_id, -1),
3323: sysdate,
3324: NVL(FND_GLOBAL.user_id,-1),
3325: 1);

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

3318: p_acct_use_rec.xtr_asset_ccid,
3319: p_acct_use_rec.ar_bank_charges_ccid, -- 7437641
3320: sysdate,
3321: NVL(FND_GLOBAL.user_id,-1),
3322: NVL(FND_GLOBAL.login_id, -1),
3323: sysdate,
3324: NVL(FND_GLOBAL.user_id,-1),
3325: 1);
3326:

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

3320: sysdate,
3321: NVL(FND_GLOBAL.user_id,-1),
3322: NVL(FND_GLOBAL.login_id, -1),
3323: sysdate,
3324: NVL(FND_GLOBAL.user_id,-1),
3325: 1);
3326:
3327: OPEN c_acct_use_rowid;
3328: FETCH c_acct_use_rowid INTO l_acct_use_rowid;

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

3588: attribute13 = p_acct_use_rec.attribute13,
3589: attribute14 = p_acct_use_rec.attribute14,
3590: attribute15 = p_acct_use_rec.attribute15,
3591: last_update_date = sysdate,
3592: last_update_login = NVL(FND_GLOBAL.login_id,-1),
3593: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3594: object_version_number = l_old_use_ovn + 1
3595: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3596: IF (SQL%NOTFOUND) THEN

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

3589: attribute14 = p_acct_use_rec.attribute14,
3590: attribute15 = p_acct_use_rec.attribute15,
3591: last_update_date = sysdate,
3592: last_update_login = NVL(FND_GLOBAL.login_id,-1),
3593: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3594: object_version_number = l_old_use_ovn + 1
3595: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3596: IF (SQL%NOTFOUND) THEN
3597: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT_USE');

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

3627: bank_interest_income_ccid = p_acct_use_rec.bank_interest_income_ccid,
3628: xtr_asset_ccid = p_acct_use_rec.xtr_asset_ccid,
3629: ar_bank_charges_ccid = p_acct_use_rec.ar_bank_charges_ccid, -- 7437641
3630: last_update_date = sysdate,
3631: last_update_login = NVL(FND_GLOBAL.login_id,-1),
3632: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3633: object_version_number = l_old_ccid_ovn + 1
3634: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3635: p_ccid_ovn := l_old_ccid_ovn + 1;

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

3628: xtr_asset_ccid = p_acct_use_rec.xtr_asset_ccid,
3629: ar_bank_charges_ccid = p_acct_use_rec.ar_bank_charges_ccid, -- 7437641
3630: last_update_date = sysdate,
3631: last_update_login = NVL(FND_GLOBAL.login_id,-1),
3632: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3633: object_version_number = l_old_ccid_ovn + 1
3634: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3635: p_ccid_ovn := l_old_ccid_ovn + 1;
3636: END IF;