[Home] [Help]
1455: /* end initialization of variable */
1456:
1457: ------------------------------------------------------------------
1458: -- Insert Forecasts in the given range from AS_INTERNAL_FORECASTS,
1459: -- AS_FST_SALES_CATEGORIES and AS_FORECAST_CATEGORIES.
1460: ------------------------------------------------------------------
1461:
1462: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_PROCEDURE) THEN
1463: bil_bi_util_collection_pkg.writeLog(
1607: NULL opp_forecast_amt_s
1608: FROM
1609: as_internal_forecasts aif,
1610: bil_bi_new_fst_id bnfi,
1611: as_fst_sales_categories asfc,
1612: bil_bi_currency_rate rates
1613: WHERE
1614: aif.forecast_id = bnfi.forecast_id
1615: AND aif.status_code = 'SUBMITTED'
1626: (
1627: SELECT
1628: afsc1.forecast_category_id
1629: FROM
1630: as_fst_sales_categories afsc1
1631: WHERE
1632: NVL(afsc1.end_date_active,SYSDATE) >= SYSDATE
1633: AND afsc1.start_date_active <= SYSDATE
1634: AND NOT(NVL(interest_type_id,-1)<0 AND product_category_id IS NULL)
3358: SELECT
3359: afsc1.forecast_category_id,
3360: afsc_tl.forecast_category_name
3361: FROM
3362: as_fst_sales_categories afsc1,
3363: as_forecast_categories_tl afsc_tl
3364: WHERE
3365: afsc1.forecast_category_id = afsc_tl.forecast_category_id
3366: AND afsc_tl.LANGUAGE = userenv('LANG')
3413: SELECT
3414: COUNT(1)
3415: INTO l_cnt
3416: FROM
3417: as_fst_sales_categories afsc1
3418: WHERE
3419: NVL(afsc1.end_date_active,SYSDATE) >= SYSDATE
3420: AND afsc1.start_date_active <= SYSDATE
3421: AND afsc1.product_category_id IS NULL
3421: AND afsc1.product_category_id IS NULL
3422: AND NVL(afsc1.interest_type_id,-1) > 0;
3423:
3424:
3425: IF(l_cnt>0) THEN -- Product categories are NULL in as_fst_sales_categories table
3426:
3427: IF bil_bi_util_collection_pkg.chkLogLevel(fnd_log.LEVEL_EVENT) THEN
3428: bil_bi_util_collection_pkg.writeLog
3429: (
3428: bil_bi_util_collection_pkg.writeLog
3429: (
3430: p_log_level => fnd_log.LEVEL_EVENT,
3431: p_module => g_pkg || l_proc,
3432: p_msg => 'There are product categories in as_fst_sales_categories with value NULL'
3433: );
3434: END IF;
3435:
3436:
3447: SELECT
3448: afsc1.forecast_category_id,
3449: afsc_tl.forecast_category_name
3450: FROM
3451: as_fst_sales_categories afsc1,
3452: as_forecast_categories_tl afsc_tl
3453: WHERE
3454: afsc1.forecast_category_id = afsc_tl.forecast_category_id
3455: AND afsc_tl.LANGUAGE = userenv('LANG')