DBA Data[Home] [Help]

APPS.HR_EDW_WRK_CMPSTN_F_C dependencies on EDW_COLLECTION_UTIL

Line 19: RETURN edw_collection_util.source_same_as_target;

15: IS
16:
17: BEGIN
18: --
19: RETURN edw_collection_util.source_same_as_target;
20: --
21: END LOCAL_SAME_AS_REMOTE;
22: --
23: --

Line 652: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN

648: Begin
649: g_local_same_as_remote := LOCAL_SAME_AS_REMOTE;
650: Errbuf :=NULL;
651: Retcode:=0;
652: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
653: errbuf := fnd_message.get;
654: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
655: Return;
656: END IF;

Line 659: HR_EDW_WRK_CMPSTN_F_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset;

655: Return;
656: END IF;
657: --
658: IF (p_from_date IS NULL) THEN
659: HR_EDW_WRK_CMPSTN_F_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset;
660: ELSE
661: HR_EDW_WRK_CMPSTN_F_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
662: END IF;
663: --

Line 665: HR_EDW_WRK_CMPSTN_F_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

661: HR_EDW_WRK_CMPSTN_F_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
662: END IF;
663: --
664: IF (p_to_date IS NULL) THEN
665: HR_EDW_WRK_CMPSTN_F_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
666: ELSE
667: HR_EDW_WRK_CMPSTN_F_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
668: END IF;
669: --

Line 770: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, l_date1, l_date2);

766: -- -----------------------------------------------------------------------
767: --
768: DROP_INDEX;
769: --
770: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, l_date1, l_date2);
771: --
772: Exception When others then
773: --
774: DROP_INDEX;

Line 780: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, l_date1, l_date2);

776: Errbuf:=sqlerrm;
777: Retcode:=sqlcode;
778: l_exception_msg := Retcode || ':' || Errbuf;
779: rollback;
780: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, l_date1, l_date2);
781: raise;
782: --
783: End Push;
784: --