APPS.HR_EDW_WRK_CMPSTN_F_C dependencies on HR_EDW_WRK_CMPSTN_F_C

Line 1: Package Body HR_EDW_WRK_CMPSTN_F_C AS

1: Package Body HR_EDW_WRK_CMPSTN_F_C AS
2: /* $Header: hriepwcp.pkb 115.17 2003/12/19 08:07:56 vsethi noship $ */
3: --
4: G_PUSH_DATE_RANGE1 Date:=Null;
5: G_PUSH_DATE_RANGE2 Date:=Null;

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 661: HR_EDW_WRK_CMPSTN_F_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');

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: --
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;

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 667: HR_EDW_WRK_CMPSTN_F_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');

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: --
670: l_date1 := g_push_date_range1;
671: l_date2 := g_push_date_range2;

Line 785: End HR_EDW_WRK_CMPSTN_F_C;

781: raise;
782: --
783: End Push;
784: --
785: End HR_EDW_WRK_CMPSTN_F_C;