DBA Data[Home] [Help]

APPS.BIL_TX_UTIL_RPT_PKG dependencies on FND_PROFILE

Line 705: x_DebugMode := FND_PROFILE.Value('BIS_PMF_DEBUG');

701: x_DebugMode OUT NOCOPY VARCHAR2
702: ) IS
703:
704: BEGIN
705: x_DebugMode := FND_PROFILE.Value('BIS_PMF_DEBUG');
706:
707: END;
708:
709:

Line 806: l_period_type := NVL(FND_PROFILE.VALUE('ASN_FRCST_DEFAULT_PERIOD_TYPE'), 'Month');

802: l_period_type VARCHAR2(100);
803:
804: BEGIN
805:
806: l_period_type := NVL(FND_PROFILE.VALUE('ASN_FRCST_DEFAULT_PERIOD_TYPE'), 'Month');
807:
808: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN
809: fnd_message.set_name('FND','SQL_PLSQL_ERROR'); -- Seeded Message
810: fnd_message.set_token('Error is : ' ,SQLCODE);

Line 832: WHERE period_type = FND_PROFILE.VALUE('ASN_FRCST_DEFAULT_PERIOD_TYPE')

828: BEGIN
829:
830: SELECT period_name INTO l_period_name
831: FROM gl_periods
832: WHERE period_type = FND_PROFILE.VALUE('ASN_FRCST_DEFAULT_PERIOD_TYPE')
833: AND period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
834: AND trunc(sysdate) >= start_date and trunc(sysdate) <= end_date;
835:
836: RETURN l_period_name;

Line 833: AND period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')

829:
830: SELECT period_name INTO l_period_name
831: FROM gl_periods
832: WHERE period_type = FND_PROFILE.VALUE('ASN_FRCST_DEFAULT_PERIOD_TYPE')
833: AND period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
834: AND trunc(sysdate) >= start_date and trunc(sysdate) <= end_date;
835:
836: RETURN l_period_name;
837:

Line 861: l_currency_code := NVL(fnd_profile.value('ICX_PREFERRED_CURRENCY'),'USD');

857: l_currency_code VARCHAR2(100);
858:
859: BEGIN
860:
861: l_currency_code := NVL(fnd_profile.value('ICX_PREFERRED_CURRENCY'),'USD');
862:
863: RETURN l_currency_code;
864:
865: IF BIL_TX_UTIL_RPT_PKG.chkLogLevel(fnd_log.LEVEL_UNEXPECTED) THEN

Line 955: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')

951:
952: SELECT start_date
953: INTO l_from_date
954: FROM gl_periods
955: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
956: AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
957: AND ADD_MONTHS(end_date, 6)
958: AND ADJUSTMENT_PERIOD_FLAG = 'N'
959: AND period_name = p_from_period_name;

Line 1007: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')

1003: */
1004: SELECT end_date
1005: INTO l_to_date
1006: FROM gl_periods
1007: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
1008: AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
1009: AND ADD_MONTHS(end_date, 6)
1010: AND ADJUSTMENT_PERIOD_FLAG = 'N'
1011: AND period_name = p_to_period_name;

Line 1163: l_default_period := NVL(FND_PROFILE.VALUE('ASN_FRCST_DEFAULT_PERIOD_TYPE'), 'Month');

1159: l_start_date DATE;
1160: l_default_start_period_id NUMBER;
1161:
1162: BEGIN
1163: l_default_period := NVL(FND_PROFILE.VALUE('ASN_FRCST_DEFAULT_PERIOD_TYPE'), 'Month');
1164:
1165: /*
1166: SELECT start_Date
1167: INTO l_start_date

Line 1177: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')

1173:
1174: SELECT start_date
1175: INTO l_start_date
1176: FROM gl_periods
1177: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
1178: AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
1179: AND ADD_MONTHS(end_date, 6)
1180: AND ADJUSTMENT_PERIOD_FLAG = 'N'
1181: AND period_type = l_default_period

Line 1199: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')

1195: SELECT PERIOD_YEAR||DECODE(LENGTH(QUARTER_NUM), 1, 0||QUARTER_NUM, QUARTER_NUM)||
1196: DECODE(LENGTH(PERIOD_NUM), 1, 0||PERIOD_NUM, PERIOD_NUM)
1197: INTO l_default_start_period_id
1198: FROM gl_periods
1199: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
1200: AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
1201: AND ADD_MONTHS(end_date, 6)
1202: AND ADJUSTMENT_PERIOD_FLAG = 'N'
1203: AND period_type = l_default_period

Line 1244: l_default_period := NVL(FND_PROFILE.VALUE('ASN_FRCST_DEFAULT_PERIOD_TYPE'), 'Month');

1240: l_end_date DATE;
1241: l_default_end_period_id NUMBER;
1242:
1243: BEGIN
1244: l_default_period := NVL(FND_PROFILE.VALUE('ASN_FRCST_DEFAULT_PERIOD_TYPE'), 'Month');
1245:
1246: /*
1247: SELECT end_Date
1248: INTO l_end_date

Line 1257: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')

1253:
1254: SELECT end_date
1255: INTO l_end_date
1256: FROM gl_periods
1257: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
1258: AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
1259: AND ADD_MONTHS(end_date, 6)
1260: AND ADJUSTMENT_PERIOD_FLAG = 'N'
1261: AND period_type = l_default_period

Line 1277: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')

1273: SELECT PERIOD_YEAR||DECODE(LENGTH(QUARTER_NUM), 1, 0||QUARTER_NUM, QUARTER_NUM)||
1274: DECODE(LENGTH(PERIOD_NUM), 1, 0||PERIOD_NUM, PERIOD_NUM)
1275: INTO l_default_end_period_id
1276: FROM gl_periods
1277: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
1278: AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
1279: AND ADD_MONTHS(end_date, 6)
1280: AND ADJUSTMENT_PERIOD_FLAG = 'N'
1281: AND period_type = l_default_period

Line 1321: SELECT FND_PROFILE.VALUE('ASN_FRCST_CREDIT_TYPE_ID')

1317: l_credit_type_id NUMBER;
1318: BEGIN
1319:
1320: /*
1321: SELECT FND_PROFILE.VALUE('ASN_FRCST_CREDIT_TYPE_ID')
1322: INTO l_credit_type_id
1323: FROM DUAL;
1324: IF SQL%NOTFOUND THEN
1325: l_credit_type_id := 1;

Line 1329: l_credit_type_id := NVL(FND_PROFILE.VALUE('ASN_FRCST_CREDIT_TYPE_ID'),1);

1325: l_credit_type_id := 1;
1326: END IF;
1327: */
1328:
1329: l_credit_type_id := NVL(FND_PROFILE.VALUE('ASN_FRCST_CREDIT_TYPE_ID'),1);
1330:
1331:
1332: RETURN l_credit_type_id; --Default to Close Date in the dropdown
1333:

Line 1397: l_win_prob := FND_PROFILE.Value('ASN_OPP_WIN_PROBABILITY');

1393: l_win_prob VARCHAR2(100);
1394:
1395: BEGIN
1396:
1397: l_win_prob := FND_PROFILE.Value('ASN_OPP_WIN_PROBABILITY');
1398:
1399: RETURN NVL(l_win_prob,0);
1400:
1401: END GET_WIN_PROB;