DBA Data[Home] [Help]

APPS.OKC_RENEWAL_OUTCOME_PUB dependencies on FND_PROFILE

Line 3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: Package Body OKC_RENEWAL_OUTCOME_PUB AS
2: /* $Header: OKCPORWB.pls 120.0 2005/05/25 19:33:46 appldev noship $*/
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: PROCEDURE Renewal_Outcome( p_api_version IN NUMBER
6: ,p_init_msg_list IN VARCHAR2
7: ,x_return_status OUT NOCOPY VARCHAR2

Line 153: l_new_contract_modifier := fnd_profile.value('OKC_CONTRACT_IDENTIFIER')|| sysdate || To_char(sysdate,' HH24:MI:SS');

149: l_perpetual_flag:=p_perpetual_flag;
150: End If;
151:
152: -- default contract number
153: l_new_contract_modifier := fnd_profile.value('OKC_CONTRACT_IDENTIFIER')|| sysdate || To_char(sysdate,' HH24:MI:SS');
154:
155: -- get start date (and end date if required) of new contract (i.e. end date of old contract + 1)
156: OPEN c_get_dates;
157: FETCH c_get_dates INTO l_default_contract_number, l_orig_start_date, l_orig_end_date;