APPS.CE_ZBA_DEAL_GENERATION dependencies on FND_PROFILE

Line 4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');

1: PACKAGE BODY CE_ZBA_DEAL_GENERATION AS
2: /* $Header: cezdgenb.pls 120.11 2006/05/12 14:01:22 svali noship $ */
3:
4: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
5:
6: --
7: -- MAIN CURSORS
8: --

Line 103: v_acct_type := FND_PROFILE.VALUE_WNPS('CE_BANK_ACCOUNT_SECURITY_ACCESS');

99:
100: FUNCTION get_security_account_type(p_account_type VARCHAR2) RETURN VARCHAR2 IS
101: v_acct_type VARCHAR2(25);
102: BEGIN
103: v_acct_type := FND_PROFILE.VALUE_WNPS('CE_BANK_ACCOUNT_SECURITY_ACCESS');
104: IF (v_acct_type = 'ALL' AND p_account_type <> 'EXTERNAL') THEN
105: v_acct_type := p_account_type;
106: END IF;
107: RETURN v_acct_type;

Line 582: if fnd_profile.value('CE_BANK_ACCOUNT_TRANSFERS') = 'XTR' then

578: to_number(NULL), 'CE_NO_SWEEP_STMT_LINE');
579: EXIT;
580: cep_standard.debug('>>validate existing of unreconciled sweep lines');
581: else --Validate the bank account is an authorized treasury account
582: if fnd_profile.value('CE_BANK_ACCOUNT_TRANSFERS') = 'XTR' then
583: select count(1) into l_count
584: from ce_bank_accounts ba, ce_bank_acct_uses_all bau
585: where ba.bank_account_id = CE_ZBA_DEAL_GENERATION.csh_bank_account_id
586: and bau.bank_account_id = ba.bank_account_id

Line 842: fnd_profile.get('CONC_REQUEST_ID', reqid);

838:
839: --
840: -- Get original request id
841: --
842: fnd_profile.get('CONC_REQUEST_ID', reqid);
843: request_id := to_number(reqid);
844: --
845: -- Get print options
846: --