391: BEGIN
392: /* Variable Intialization */
393: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
394:
395: -- IF(FND_PROFILE.Value('BIL_BI_ASN_IMPLEMENTED') = 'Y') THEN
396:
397: /*
398: IF(BIL_BI_UTIL_PKG.GET_ASN_PROFILE = 'Y') THEN
399: x_FstCrdtType := FND_PROFILE.Value('ASN_FRCST_CREDIT_TYPE_ID');
395: -- IF(FND_PROFILE.Value('BIL_BI_ASN_IMPLEMENTED') = 'Y') THEN
396:
397: /*
398: IF(BIL_BI_UTIL_PKG.GET_ASN_PROFILE = 'Y') THEN
399: x_FstCrdtType := FND_PROFILE.Value('ASN_FRCST_CREDIT_TYPE_ID');
400: ELSE
401: x_FstCrdtType := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
402: END IF;
403: */
397: /*
398: IF(BIL_BI_UTIL_PKG.GET_ASN_PROFILE = 'Y') THEN
399: x_FstCrdtType := FND_PROFILE.Value('ASN_FRCST_CREDIT_TYPE_ID');
400: ELSE
401: x_FstCrdtType := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
402: END IF;
403: */
404:
405: x_FstCrdtType := FND_PROFILE.Value('ASN_FRCST_CREDIT_TYPE_ID');
401: x_FstCrdtType := FND_PROFILE.Value('AS_FORECAST_CREDIT_TYPE_ID');
402: END IF;
403: */
404:
405: x_FstCrdtType := FND_PROFILE.Value('ASN_FRCST_CREDIT_TYPE_ID');
406:
407:
408:
409: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
602:
603: BEGIN
604: /* Variable Intialization */
605: g_pkg := 'bil.patch.115.sql.BIL_BI_UTIL_PKG.';
606: x_DebugMode := FND_PROFILE.Value('BIS_PMF_DEBUG');
607:
608: EXCEPTION
609: WHEN OTHERS THEN
610: