DBA Data[Home] [Help]

APPS.CE_BANK_PUB dependencies on FND_GLOBAL

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

2245: p_acct_rec.attribute13,
2246: p_acct_rec.attribute14,
2247: p_acct_rec.attribute15,
2248: sysdate,
2249: NVL(FND_GLOBAL.user_id,-1),
2250: NVL(FND_GLOBAL.login_id, -1),
2251: sysdate,
2252: NVL(FND_GLOBAL.user_id,-1),
2253: 1,

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

2246: p_acct_rec.attribute14,
2247: p_acct_rec.attribute15,
2248: sysdate,
2249: NVL(FND_GLOBAL.user_id,-1),
2250: NVL(FND_GLOBAL.login_id, -1),
2251: sysdate,
2252: NVL(FND_GLOBAL.user_id,-1),
2253: 1,
2254: p_acct_rec.xtr_bank_account_reference);

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

2248: sysdate,
2249: NVL(FND_GLOBAL.user_id,-1),
2250: NVL(FND_GLOBAL.login_id, -1),
2251: sysdate,
2252: NVL(FND_GLOBAL.user_id,-1),
2253: 1,
2254: p_acct_rec.xtr_bank_account_reference);
2255: OPEN c_acct_rowid;
2256: FETCH c_acct_rowid INTO l_acct_rowid;

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

2612: attribute13 = p_acct_rec.attribute13,
2613: attribute14 = p_acct_rec.attribute14,
2614: attribute15 = p_acct_rec.attribute15,
2615: last_update_date = sysdate,
2616: last_update_login = NVL(FND_GLOBAL.login_id,-1),
2617: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2618: object_version_number = l_old_ovn + 1,
2619: xtr_bank_account_reference = p_acct_rec.xtr_bank_account_reference
2620: WHERE bank_account_id = p_acct_rec.bank_account_id;

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

2613: attribute14 = p_acct_rec.attribute14,
2614: attribute15 = p_acct_rec.attribute15,
2615: last_update_date = sysdate,
2616: last_update_login = NVL(FND_GLOBAL.login_id,-1),
2617: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
2618: object_version_number = l_old_ovn + 1,
2619: xtr_bank_account_reference = p_acct_rec.xtr_bank_account_reference
2620: WHERE bank_account_id = p_acct_rec.bank_account_id;
2621: IF (SQL%NOTFOUND) THEN

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

2888: p_acct_use_rec.attribute13,
2889: p_acct_use_rec.attribute14,
2890: p_acct_use_rec.attribute15,
2891: sysdate,
2892: NVL(FND_GLOBAL.user_id,-1),
2893: NVL(FND_GLOBAL.login_id, -1),
2894: sysdate,
2895: NVL(FND_GLOBAL.user_id,-1),
2896: 1);

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

2889: p_acct_use_rec.attribute14,
2890: p_acct_use_rec.attribute15,
2891: sysdate,
2892: NVL(FND_GLOBAL.user_id,-1),
2893: NVL(FND_GLOBAL.login_id, -1),
2894: sysdate,
2895: NVL(FND_GLOBAL.user_id,-1),
2896: 1);
2897:

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

2891: sysdate,
2892: NVL(FND_GLOBAL.user_id,-1),
2893: NVL(FND_GLOBAL.login_id, -1),
2894: sysdate,
2895: NVL(FND_GLOBAL.user_id,-1),
2896: 1);
2897:
2898: INSERT INTO CE_GL_ACCOUNTS_CCID (
2899: BANK_ACCT_USE_ID,

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

2951: p_acct_use_rec.bank_interest_income_ccid,
2952: p_acct_use_rec.xtr_asset_ccid,
2953: p_acct_use_rec.ar_bank_charges_ccid, -- 7437641
2954: sysdate,
2955: NVL(FND_GLOBAL.user_id,-1),
2956: NVL(FND_GLOBAL.login_id, -1),
2957: sysdate,
2958: NVL(FND_GLOBAL.user_id,-1),
2959: 1);

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

2952: p_acct_use_rec.xtr_asset_ccid,
2953: p_acct_use_rec.ar_bank_charges_ccid, -- 7437641
2954: sysdate,
2955: NVL(FND_GLOBAL.user_id,-1),
2956: NVL(FND_GLOBAL.login_id, -1),
2957: sysdate,
2958: NVL(FND_GLOBAL.user_id,-1),
2959: 1);
2960:

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

2954: sysdate,
2955: NVL(FND_GLOBAL.user_id,-1),
2956: NVL(FND_GLOBAL.login_id, -1),
2957: sysdate,
2958: NVL(FND_GLOBAL.user_id,-1),
2959: 1);
2960:
2961: OPEN c_acct_use_rowid;
2962: FETCH c_acct_use_rowid INTO l_acct_use_rowid;

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

3226: attribute13 = p_acct_use_rec.attribute13,
3227: attribute14 = p_acct_use_rec.attribute14,
3228: attribute15 = p_acct_use_rec.attribute15,
3229: last_update_date = sysdate,
3230: last_update_login = NVL(FND_GLOBAL.login_id,-1),
3231: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3232: object_version_number = l_old_use_ovn + 1
3233: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3234: IF (SQL%NOTFOUND) THEN

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

3227: attribute14 = p_acct_use_rec.attribute14,
3228: attribute15 = p_acct_use_rec.attribute15,
3229: last_update_date = sysdate,
3230: last_update_login = NVL(FND_GLOBAL.login_id,-1),
3231: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3232: object_version_number = l_old_use_ovn + 1
3233: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3234: IF (SQL%NOTFOUND) THEN
3235: fnd_message.set_name('CE', 'CE_API_NO_ACCOUNT_USE');

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

3265: bank_interest_income_ccid = p_acct_use_rec.bank_interest_income_ccid,
3266: xtr_asset_ccid = p_acct_use_rec.xtr_asset_ccid,
3267: ar_bank_charges_ccid = p_acct_use_rec.bank_charges_ccid, -- 7437641
3268: last_update_date = sysdate,
3269: last_update_login = NVL(FND_GLOBAL.login_id,-1),
3270: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3271: object_version_number = l_old_ccid_ovn + 1
3272: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3273: p_ccid_ovn := l_old_ccid_ovn + 1;

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

3266: xtr_asset_ccid = p_acct_use_rec.xtr_asset_ccid,
3267: ar_bank_charges_ccid = p_acct_use_rec.bank_charges_ccid, -- 7437641
3268: last_update_date = sysdate,
3269: last_update_login = NVL(FND_GLOBAL.login_id,-1),
3270: last_updated_by = NVL(FND_GLOBAL.user_id,-1),
3271: object_version_number = l_old_ccid_ovn + 1
3272: WHERE bank_acct_use_id = p_acct_use_rec.bank_acct_use_id;
3273: p_ccid_ovn := l_old_ccid_ovn + 1;
3274: END IF;