eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ISC_DBI_BOOK_SUM2_F_C dependencies on ISC_DBI_BOOK_SUM2_F_C

Line 1: PACKAGE BODY ISC_DBI_BOOK_SUM2_F_C AS

1: PACKAGE BODY ISC_DBI_BOOK_SUM2_F_C AS
2: /* $Header: ISCSCF7B.pls 120.6 2006/06/07 22:58:58 scheung noship $ */
3:
4: g_errbuf VARCHAR2(2000) := NULL;
5: g_retcode VARCHAR2(200) := NULL;

Line 553: SELECT pk1, ISC_DBI_BOOK_SUM2_F_C.get_cust_product_line_id(tmp.sold_to_org_id,tmp.service_reference_line_id)

549: INSERT /*+ APPEND */
550: INTO isc_service_book_sum2 F(
551: LINE_ID,
552: SERVICE_PARENT_LINE_ID)
553: SELECT pk1, ISC_DBI_BOOK_SUM2_F_C.get_cust_product_line_id(tmp.sold_to_org_id,tmp.service_reference_line_id)
554: FROM isc_tmp_book_sum2 tmp
555: WHERE service_reference_type_code = 'CUSTOMER_PRODUCT';
556:
557: FII_UTIL.Stop_Timer;

Line 992: SELECT pk1, ISC_DBI_BOOK_SUM2_F_C.get_cust_product_line_id(tmp.sold_to_org_id,tmp.service_reference_line_id)

988: INSERT
989: INTO isc_service_book_sum2 F(
990: LINE_ID,
991: SERVICE_PARENT_LINE_ID)
992: SELECT pk1, ISC_DBI_BOOK_SUM2_F_C.get_cust_product_line_id(tmp.sold_to_org_id,tmp.service_reference_line_id)
993: FROM isc_tmp_book_sum2 tmp
994: WHERE service_reference_type_code = 'CUSTOMER_PRODUCT';
995:
996: FII_UTIL.Stop_Timer;

Line 2333: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,

2329: BIS_COLLECTION_UTILITIES.WRAPUP(
2330: TRUE,
2331: g_row_count,
2332: NULL,
2333: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,
2334: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date
2335: );
2336:
2337: RETURN (1);

Line 2334: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date

2330: TRUE,
2331: g_row_count,
2332: NULL,
2333: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,
2334: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date
2335: );
2336:
2337: RETURN (1);
2338:

Line 2384: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date := g_global_start_date;

2380: IF (CHECK_SETUP = -1)
2381: THEN RAISE l_failure;
2382: END IF;
2383:
2384: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date := g_global_start_date;
2385: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date := sysdate;
2386:
2387: BIS_COLLECTION_UTILITIES.put_line( 'The collection date range is from '||
2388: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||

Line 2385: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date := sysdate;

2381: THEN RAISE l_failure;
2382: END IF;
2383:
2384: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date := g_global_start_date;
2385: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date := sysdate;
2386:
2387: BIS_COLLECTION_UTILITIES.put_line( 'The collection date range is from '||
2388: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
2389: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));

Line 2531: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,

2527: BIS_COLLECTION_UTILITIES.WRAPUP(
2528: FALSE,
2529: g_row_count,
2530: g_errbuf,
2531: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,
2532: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date
2533: );
2534:
2535: WHEN OTHERS THEN

Line 2532: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date

2528: FALSE,
2529: g_row_count,
2530: g_errbuf,
2531: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,
2532: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date
2533: );
2534:
2535: WHEN OTHERS THEN
2536: ROLLBACK;

Line 2547: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,

2543: BIS_COLLECTION_UTILITIES.WRAPUP(
2544: FALSE,
2545: g_row_count,
2546: g_errbuf,
2547: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,
2548: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date
2549: );
2550:
2551: END load_fact;

Line 2548: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date

2544: FALSE,
2545: g_row_count,
2546: g_errbuf,
2547: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,
2548: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date
2549: );
2550:
2551: END load_fact;
2552:

Line 2582: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date := l_period_to;

2578: return;
2579: END IF;
2580:
2581: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_F', l_start, l_end, l_period_from, l_period_to);
2582: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date := l_period_to;
2583: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date := sysdate;
2584:
2585: IF (CHECK_SETUP = -1)
2586: THEN RAISE l_failure;

Line 2583: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date := sysdate;

2579: END IF;
2580:
2581: BIS_COLLECTION_UTILITIES.get_last_refresh_dates('ISC_BOOK_SUM2_F', l_start, l_end, l_period_from, l_period_to);
2582: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date := l_period_to;
2583: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date := sysdate;
2584:
2585: IF (CHECK_SETUP = -1)
2586: THEN RAISE l_failure;
2587: END IF;

Line 2786: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,

2782: BIS_COLLECTION_UTILITIES.WRAPUP(
2783: FALSE,
2784: g_row_count,
2785: g_errbuf,
2786: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,
2787: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date
2788: );
2789:
2790: WHEN OTHERS THEN

Line 2787: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date

2783: FALSE,
2784: g_row_count,
2785: g_errbuf,
2786: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,
2787: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date
2788: );
2789:
2790: WHEN OTHERS THEN
2791: ROLLBACK;

Line 2802: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,

2798: BIS_COLLECTION_UTILITIES.WRAPUP(
2799: FALSE,
2800: g_row_count,
2801: g_errbuf,
2802: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,
2803: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date
2804: );
2805:
2806: END update_fact;

Line 2803: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date

2799: FALSE,
2800: g_row_count,
2801: g_errbuf,
2802: ISC_DBI_BOOK_SUM2_F_C.g_push_from_date,
2803: ISC_DBI_BOOK_SUM2_F_C.g_push_to_date
2804: );
2805:
2806: END update_fact;
2807:

Line 3000: END ISC_DBI_BOOK_SUM2_F_C;

2996: BEGIN
2997: null;
2998: END update_sales_fact_dummy;
2999:
3000: END ISC_DBI_BOOK_SUM2_F_C;
3001: