DBA Data[Home] [Help]

APPS.BIL_DO_L1_OPPTY_SUMRY_PKG dependencies on FND_PROFILE

Line 303: l_period_type VARCHAR2(50) := FND_PROFILE.VALUE('AS_FORECAST_CALENDAR');

299: l_quote VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(39); -- single quote
300:
301: /*Bind variables*/
302: l_collection_date DATE ;--:= trunc(sysdate-1);
303: l_period_type VARCHAR2(50) := FND_PROFILE.VALUE('AS_FORECAST_CALENDAR');
304: l_credit_type VARCHAR2(50) := FND_PROFILE.VALUE('ASF_DEFAULT_FORECAST_CREDIT_TYPE');
305: l_delete_flag VARCHAR2(1) := 'N';
306: l_enabled_flag VARCHAR2(1) := 'Y';
307: l_sysdate DATE := sysdate;

Line 304: l_credit_type VARCHAR2(50) := FND_PROFILE.VALUE('ASF_DEFAULT_FORECAST_CREDIT_TYPE');

300:
301: /*Bind variables*/
302: l_collection_date DATE ;--:= trunc(sysdate-1);
303: l_period_type VARCHAR2(50) := FND_PROFILE.VALUE('AS_FORECAST_CALENDAR');
304: l_credit_type VARCHAR2(50) := FND_PROFILE.VALUE('ASF_DEFAULT_FORECAST_CREDIT_TYPE');
305: l_delete_flag VARCHAR2(1) := 'N';
306: l_enabled_flag VARCHAR2(1) := 'Y';
307: l_sysdate DATE := sysdate;
308: