DBA Data[Home] [Help]

APPS.XTR_NOTIONAL_BANK_ACCOUNTS dependencies on FND_GLOBAL

Line 127: WHERE user_id = FND_GLOBAL.USER_ID;

123:
124: cursor dealer_details IS
125: SELECT dealer_code
126: FROM xtr_dealer_codes
127: WHERE user_id = FND_GLOBAL.USER_ID;
128:
129: l_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;
130: l_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
131: l_currency XTR_BANK_ACCOUNTS.CURRENCY%TYPE;

Line 279: nvl(l_created_by, FND_GLOBAL.user_id), sysdate,

275: l_portfolio_code, l_int_calc_basis,
276: l_rounding_type, l_day_count_type,
277: l_code_combination_id, 'NO_REVAL',
278: 'Y', 'C', p_cashpool_id,
279: nvl(l_created_by, FND_GLOBAL.user_id), sysdate,
280: nvl(l_updated_by, FND_GLOBAL.user_id), sysdate);
281: EXCEPTION
282: WHEN OTHERS THEN
283: x_return_status := 'N';

Line 280: nvl(l_updated_by, FND_GLOBAL.user_id), sysdate);

276: l_rounding_type, l_day_count_type,
277: l_code_combination_id, 'NO_REVAL',
278: 'Y', 'C', p_cashpool_id,
279: nvl(l_created_by, FND_GLOBAL.user_id), sysdate,
280: nvl(l_updated_by, FND_GLOBAL.user_id), sysdate);
281: EXCEPTION
282: WHEN OTHERS THEN
283: x_return_status := 'N';
284: RAISE FND_API.G_EXC_ERROR;

Line 343: WHERE user_id = FND_GLOBAL.USER_ID;

339:
340: cursor dealer_details IS
341: SELECT dealer_code
342: FROM xtr_dealer_codes
343: WHERE user_id = FND_GLOBAL.USER_ID;
344:
345: l_conc_account_id CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE;
346:
347: l_bank_code XTR_BANK_ACCOUNTS.BANK_CODE%TYPE;

Line 404: FND_GLOBAL.user_id),

400: rounding_type = l_rounding_type,
401: day_count_type = l_day_count_type,
402: code_combination_id = l_code_combination_id,
403: updated_by = nvl(l_updated_by,
404: FND_GLOBAL.user_id),
405: updated_on = sysdate
406: WHERE cashpool_id = p_cashpool_id
407: AND setoff_account_yn = 'Y';
408: EXCEPTION

Line 422: FND_GLOBAL.user_id),

418: interest_calculation_basis = l_int_calc_basis,
419: rounding_type = l_rounding_type,
420: day_count_type = l_day_count_type,
421: updated_by = nvl(l_updated_by,
422: FND_GLOBAL.user_id),
423: updated_on = sysdate
424: WHERE cashpool_id = p_cashpool_id
425: AND setoff_account_yn = 'Y';
426: EXCEPTION