APPS.ISC_EDW_BOOKINGS_F_C dependencies on EDW_COLLECTION_UTIL

Line 770: EDW_COLLECTION_UTIL.Get_Dblink_Names(l_apps_to_apps,l_edw_apps_to_wh);

766: l_edw_local_instance VARCHAR2(100);
767:
768: BEGIN
769:
770: EDW_COLLECTION_UTIL.Get_Dblink_Names(l_apps_to_apps,l_edw_apps_to_wh);
771: l_stmt := 'SELECT instance_code FROM EDW_LOCAL_INSTANCE';
772: EXECUTE IMMEDIATE l_stmt INTO l_edw_local_instance;
773:
774: l_stmt := 'INSERT INTO ISC_EDW_BOOKINGS_FSTG (

Line 1031: IF (NOT EDW_COLLECTION_UTIL.Setup(l_fact_name))

1027: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
1028:
1029: g_all_or_nothing_flag := upper(p_coll_flag);
1030:
1031: IF (NOT EDW_COLLECTION_UTIL.Setup(l_fact_name))
1032: THEN
1033: g_errbuf := 'Error in function Setup : '||fnd_message.get;
1034: RAISE l_failure;
1035: END IF;

Line 1038: EDW_COLLECTION_UTIL.G_Local_Last_Push_Start_Date - EDW_COLLECTION_UTIL.G_Offset);

1034: RAISE l_failure;
1035: END IF;
1036:
1037: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date := nvl(l_from_date,
1038: EDW_COLLECTION_UTIL.G_Local_Last_Push_Start_Date - EDW_COLLECTION_UTIL.G_Offset);
1039:
1040: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date := nvl(l_to_date,
1041: EDW_COLLECTION_UTIL.G_Local_Curr_Push_Start_Date);
1042:

Line 1041: EDW_COLLECTION_UTIL.G_Local_Curr_Push_Start_Date);

1037: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date := nvl(l_from_date,
1038: EDW_COLLECTION_UTIL.G_Local_Last_Push_Start_Date - EDW_COLLECTION_UTIL.G_Offset);
1039:
1040: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date := nvl(l_to_date,
1041: EDW_COLLECTION_UTIL.G_Local_Curr_Push_Start_Date);
1042:
1043: EDW_LOG.Put_Line( 'The collection range is from '||
1044: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1045: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));

Line 1390: EDW_COLLECTION_UTIL.Wrapup(

1386:
1387:
1388: IF retcode = -1
1389: THEN
1390: EDW_COLLECTION_UTIL.Wrapup(
1391: FALSE,
1392: g_rows_collected,
1393: NULL,
1394: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,

Line 1397: EDW_COLLECTION_UTIL.Wrapup(

1393: NULL,
1394: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,
1395: ISC_EDW_BOOKINGS_F_C.G_Push_To_Date);
1396: ELSE
1397: EDW_COLLECTION_UTIL.Wrapup(
1398: TRUE,
1399: g_rows_collected,
1400: NULL,
1401: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,

Line 1418: EDW_COLLECTION_UTIL.Wrapup(

1414: WHEN L_FAILURE THEN
1415: ROLLBACK;
1416: EDW_LOG.Put_Line(g_errbuf);
1417: retcode := -1;
1418: EDW_COLLECTION_UTIL.Wrapup(
1419: FALSE,
1420: g_rows_collected,
1421: NULL,
1422: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,

Line 1429: EDW_COLLECTION_UTIL.Wrapup(

1425: ROLLBACK;
1426: g_errbuf := sqlerrm ||' - '|| sqlcode;
1427: EDW_LOG.Put_Line('Other errors : '|| g_errbuf);
1428: retcode := -1;
1429: EDW_COLLECTION_UTIL.Wrapup(
1430: FALSE,
1431: g_rows_collected,
1432: NULL,
1433: ISC_EDW_BOOKINGS_F_C.G_Push_From_Date,