APPS.HR_EDW_WRK_SPRTN_F_C dependencies on HR_EDW_WRK_SPRTN_F_C

Line 1: Package Body HR_EDW_WRK_SPRTN_F_C AS

1: Package Body HR_EDW_WRK_SPRTN_F_C AS
2: /* $Header: hriepwsp.pkb 115.10 2004/03/09 03:45:28 knarula noship $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: g_row_count Number:=0;

Line 32: HR_EDW_WRK_SPRTN_F_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset;

28: Return;
29: END IF;
30:
31: IF (p_from_date IS NULL) THEN
32: HR_EDW_WRK_SPRTN_F_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset;
33: ELSE
34: HR_EDW_WRK_SPRTN_F_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
35: END IF;
36:

Line 34: HR_EDW_WRK_SPRTN_F_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');

30:
31: IF (p_from_date IS NULL) THEN
32: HR_EDW_WRK_SPRTN_F_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset;
33: ELSE
34: HR_EDW_WRK_SPRTN_F_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
35: END IF;
36:
37: IF (p_to_date IS NULL) THEN
38: HR_EDW_WRK_SPRTN_F_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

Line 38: HR_EDW_WRK_SPRTN_F_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

34: HR_EDW_WRK_SPRTN_F_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
35: END IF;
36:
37: IF (p_to_date IS NULL) THEN
38: HR_EDW_WRK_SPRTN_F_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
39: ELSE
40: HR_EDW_WRK_SPRTN_F_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
41: END IF;
42:

Line 40: HR_EDW_WRK_SPRTN_F_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');

36:
37: IF (p_to_date IS NULL) THEN
38: HR_EDW_WRK_SPRTN_F_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
39: ELSE
40: HR_EDW_WRK_SPRTN_F_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
41: END IF;
42:
43:
44: l_date1 := g_push_date_range1;

Line 310: End HR_EDW_WRK_SPRTN_F_C;

306: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, l_date1, l_date2);
307: raise;
308:
309: End;
310: End HR_EDW_WRK_SPRTN_F_C;