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.EDW_HR_MVMNT_TYP_M_C dependencies on EDW_HR_MVMNT_TYP_M_C

Line 1: Package Body EDW_HR_MVMNT_TYP_M_C AS

1: Package Body EDW_HR_MVMNT_TYP_M_C AS
2: /* $Header: hriepmvt.pkb 120.1 2005/06/07 05:55:47 anmajumd noship $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: g_row_count Number:=0;

Line 31: EDW_HR_MVMNT_TYP_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -

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

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

30: IF (p_from_date IS NULL) THEN
31: EDW_HR_MVMNT_TYP_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -
32: EDW_COLLECTION_UTIL.g_offset;
33: ELSE
34: EDW_HR_MVMNT_TYP_M_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: EDW_HR_MVMNT_TYP_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

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

34: EDW_HR_MVMNT_TYP_M_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: EDW_HR_MVMNT_TYP_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
39: ELSE
40: EDW_HR_MVMNT_TYP_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
41: END IF;
42:

Line 40: EDW_HR_MVMNT_TYP_M_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: EDW_HR_MVMNT_TYP_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
39: ELSE
40: EDW_HR_MVMNT_TYP_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
41: END IF;
42:
43:
44: edw_log.put_line( 'The collection range is from '||

Line 45: to_char(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||

41: END IF;
42:
43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_MVMNT_TYP_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
47: edw_log.put_line(' ');
48:
49: -- -----------------------------------------------------------------------------

Line 46: to_char(EDW_HR_MVMNT_TYP_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

42:
43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_MVMNT_TYP_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
47: edw_log.put_line(' ');
48:
49: -- -----------------------------------------------------------------------------
50: -- Start of Collection , Developer Customizable Section

Line 59: Push_EDW_HR_MVMT_MVMNTS_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

55:
56: l_temp_date := sysdate;
57:
58:
59: Push_EDW_HR_MVMT_MVMNTS_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
60: Push_EDW_HR_MVMT_GAIN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
61: Push_EDW_HR_MVMT_LOSS_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
62: Push_EDW_HR_MVMT_RCTMNT_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
63: Push_EDW_HR_MVMT_SPRTN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

Line 60: Push_EDW_HR_MVMT_GAIN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

56: l_temp_date := sysdate;
57:
58:
59: Push_EDW_HR_MVMT_MVMNTS_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
60: Push_EDW_HR_MVMT_GAIN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
61: Push_EDW_HR_MVMT_LOSS_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
62: Push_EDW_HR_MVMT_RCTMNT_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
63: Push_EDW_HR_MVMT_SPRTN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
64: Push_EDW_HR_MVMT_GAIN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

Line 61: Push_EDW_HR_MVMT_LOSS_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

57:
58:
59: Push_EDW_HR_MVMT_MVMNTS_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
60: Push_EDW_HR_MVMT_GAIN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
61: Push_EDW_HR_MVMT_LOSS_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
62: Push_EDW_HR_MVMT_RCTMNT_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
63: Push_EDW_HR_MVMT_SPRTN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
64: Push_EDW_HR_MVMT_GAIN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
65: Push_EDW_HR_MVMT_LOSS_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

Line 62: Push_EDW_HR_MVMT_RCTMNT_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

58:
59: Push_EDW_HR_MVMT_MVMNTS_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
60: Push_EDW_HR_MVMT_GAIN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
61: Push_EDW_HR_MVMT_LOSS_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
62: Push_EDW_HR_MVMT_RCTMNT_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
63: Push_EDW_HR_MVMT_SPRTN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
64: Push_EDW_HR_MVMT_GAIN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
65: Push_EDW_HR_MVMT_LOSS_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
66: Push_EDW_HR_MVMT_RCTMNT_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

Line 63: Push_EDW_HR_MVMT_SPRTN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

59: Push_EDW_HR_MVMT_MVMNTS_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
60: Push_EDW_HR_MVMT_GAIN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
61: Push_EDW_HR_MVMT_LOSS_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
62: Push_EDW_HR_MVMT_RCTMNT_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
63: Push_EDW_HR_MVMT_SPRTN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
64: Push_EDW_HR_MVMT_GAIN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
65: Push_EDW_HR_MVMT_LOSS_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
66: Push_EDW_HR_MVMT_RCTMNT_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
67: Push_EDW_HR_MVMT_SPRTN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

Line 64: Push_EDW_HR_MVMT_GAIN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

60: Push_EDW_HR_MVMT_GAIN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
61: Push_EDW_HR_MVMT_LOSS_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
62: Push_EDW_HR_MVMT_RCTMNT_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
63: Push_EDW_HR_MVMT_SPRTN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
64: Push_EDW_HR_MVMT_GAIN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
65: Push_EDW_HR_MVMT_LOSS_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
66: Push_EDW_HR_MVMT_RCTMNT_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
67: Push_EDW_HR_MVMT_SPRTN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
68: Push_EDW_HR_MVMT_GAIN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

Line 65: Push_EDW_HR_MVMT_LOSS_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

61: Push_EDW_HR_MVMT_LOSS_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
62: Push_EDW_HR_MVMT_RCTMNT_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
63: Push_EDW_HR_MVMT_SPRTN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
64: Push_EDW_HR_MVMT_GAIN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
65: Push_EDW_HR_MVMT_LOSS_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
66: Push_EDW_HR_MVMT_RCTMNT_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
67: Push_EDW_HR_MVMT_SPRTN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
68: Push_EDW_HR_MVMT_GAIN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
69: Push_EDW_HR_MVMT_LOSS_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

Line 66: Push_EDW_HR_MVMT_RCTMNT_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

62: Push_EDW_HR_MVMT_RCTMNT_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
63: Push_EDW_HR_MVMT_SPRTN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
64: Push_EDW_HR_MVMT_GAIN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
65: Push_EDW_HR_MVMT_LOSS_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
66: Push_EDW_HR_MVMT_RCTMNT_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
67: Push_EDW_HR_MVMT_SPRTN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
68: Push_EDW_HR_MVMT_GAIN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
69: Push_EDW_HR_MVMT_LOSS_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
70: Push_EDW_HR_MVMT_RCTMNT_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

Line 67: Push_EDW_HR_MVMT_SPRTN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

63: Push_EDW_HR_MVMT_SPRTN_1_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
64: Push_EDW_HR_MVMT_GAIN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
65: Push_EDW_HR_MVMT_LOSS_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
66: Push_EDW_HR_MVMT_RCTMNT_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
67: Push_EDW_HR_MVMT_SPRTN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
68: Push_EDW_HR_MVMT_GAIN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
69: Push_EDW_HR_MVMT_LOSS_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
70: Push_EDW_HR_MVMT_RCTMNT_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
71: Push_EDW_HR_MVMT_SPRTN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

Line 68: Push_EDW_HR_MVMT_GAIN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

64: Push_EDW_HR_MVMT_GAIN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
65: Push_EDW_HR_MVMT_LOSS_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
66: Push_EDW_HR_MVMT_RCTMNT_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
67: Push_EDW_HR_MVMT_SPRTN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
68: Push_EDW_HR_MVMT_GAIN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
69: Push_EDW_HR_MVMT_LOSS_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
70: Push_EDW_HR_MVMT_RCTMNT_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
71: Push_EDW_HR_MVMT_SPRTN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
72:

Line 69: Push_EDW_HR_MVMT_LOSS_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

65: Push_EDW_HR_MVMT_LOSS_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
66: Push_EDW_HR_MVMT_RCTMNT_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
67: Push_EDW_HR_MVMT_SPRTN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
68: Push_EDW_HR_MVMT_GAIN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
69: Push_EDW_HR_MVMT_LOSS_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
70: Push_EDW_HR_MVMT_RCTMNT_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
71: Push_EDW_HR_MVMT_SPRTN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
72:
73:

Line 70: Push_EDW_HR_MVMT_RCTMNT_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

66: Push_EDW_HR_MVMT_RCTMNT_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
67: Push_EDW_HR_MVMT_SPRTN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
68: Push_EDW_HR_MVMT_GAIN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
69: Push_EDW_HR_MVMT_LOSS_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
70: Push_EDW_HR_MVMT_RCTMNT_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
71: Push_EDW_HR_MVMT_SPRTN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
72:
73:
74: l_duration := sysdate - l_temp_date;

Line 71: Push_EDW_HR_MVMT_SPRTN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);

67: Push_EDW_HR_MVMT_SPRTN_2_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
68: Push_EDW_HR_MVMT_GAIN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
69: Push_EDW_HR_MVMT_LOSS_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
70: Push_EDW_HR_MVMT_RCTMNT_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
71: Push_EDW_HR_MVMT_SPRTN_3_LSTG(EDW_HR_MVMNT_TYP_M_C.g_push_date_range1, EDW_HR_MVMNT_TYP_M_C.g_push_date_range2);
72:
73:
74: l_duration := sysdate - l_temp_date;
75:

Line 89: EDW_HR_MVMNT_TYP_M_C.g_exception_msg := l_exception_msg;

85: Exception When others then
86: Errbuf:=sqlerrm;
87: Retcode:=sqlcode;
88: l_exception_msg := Retcode || ':' || Errbuf;
89: EDW_HR_MVMNT_TYP_M_C.g_exception_msg := l_exception_msg;
90: rollback;
91: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_MVMNT_TYP_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);
92:
93: commit;

Line 91: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_MVMNT_TYP_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);

87: Retcode:=sqlcode;
88: l_exception_msg := Retcode || ':' || Errbuf;
89: EDW_HR_MVMNT_TYP_M_C.g_exception_msg := l_exception_msg;
90: rollback;
91: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_MVMNT_TYP_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);
92:
93: commit;
94: End;
95:

Line 148: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

144: where last_update_date between l_date1 and l_date2;
145:
146:
147: l_rows_inserted := sql%rowcount;
148: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
149: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
150: ' rows into the staging table');
151: edw_log.put_line('Commiting records for EDW_HR_MVMT_MVMNTS_LSTG');
152: commit;

Line 208: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

204: where last_update_date between l_date1 and l_date2;
205:
206:
207: l_rows_inserted := sql%rowcount;
208: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
209: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
210: ' rows into the staging table');
211: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_1_LSTG');
212: commit;

Line 268: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

264: where last_update_date between l_date1 and l_date2;
265:
266:
267: l_rows_inserted := sql%rowcount;
268: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
269: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
270: ' rows into the staging table');
271: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_1_LSTG');
272: commit;

Line 328: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

324: where last_update_date between l_date1 and l_date2;
325:
326:
327: l_rows_inserted := sql%rowcount;
328: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
329: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
330: ' rows into the staging table');
331: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_1_LSTG');
332: commit;

Line 388: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

384: where last_update_date between l_date1 and l_date2;
385:
386:
387: l_rows_inserted := sql%rowcount;
388: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
389: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
390: ' rows into the staging table');
391: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_1_LSTG');
392: commit;

Line 448: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

444: where last_update_date between l_date1 and l_date2;
445:
446:
447: l_rows_inserted := sql%rowcount;
448: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
449: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
450: ' rows into the staging table');
451: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_2_LSTG');
452: commit;

Line 508: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

504: where last_update_date between l_date1 and l_date2;
505:
506:
507: l_rows_inserted := sql%rowcount;
508: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
509: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
510: ' rows into the staging table');
511: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_2_LSTG');
512: commit;

Line 568: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

564: where last_update_date between l_date1 and l_date2;
565:
566:
567: l_rows_inserted := sql%rowcount;
568: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
569: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
570: ' rows into the staging table');
571: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_2_LSTG');
572: commit;

Line 628: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

624: where last_update_date between l_date1 and l_date2;
625:
626:
627: l_rows_inserted := sql%rowcount;
628: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
629: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
630: ' rows into the staging table');
631: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_2_LSTG');
632: commit;

Line 688: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

684: where last_update_date between l_date1 and l_date2;
685:
686:
687: l_rows_inserted := sql%rowcount;
688: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
689: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
690: ' rows into the staging table');
691: edw_log.put_line('Commiting records for EDW_HR_MVMT_GAIN_3_LSTG');
692: commit;

Line 748: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

744: where last_update_date between l_date1 and l_date2;
745:
746:
747: l_rows_inserted := sql%rowcount;
748: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
749: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
750: ' rows into the staging table');
751: edw_log.put_line('Commiting records for EDW_HR_MVMT_LOSS_3_LSTG');
752: commit;

Line 808: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

804: where last_update_date between l_date1 and l_date2;
805:
806:
807: l_rows_inserted := sql%rowcount;
808: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
809: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
810: ' rows into the staging table');
811: edw_log.put_line('Commiting records for EDW_HR_MVMT_RCTMNT_3_LSTG');
812: commit;

Line 868: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;

864: where last_update_date between l_date1 and l_date2;
865:
866:
867: l_rows_inserted := sql%rowcount;
868: EDW_HR_MVMNT_TYP_M_C.g_row_count := EDW_HR_MVMNT_TYP_M_C.g_row_count + l_rows_inserted ;
869: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
870: ' rows into the staging table');
871: edw_log.put_line('Commiting records for EDW_HR_MVMT_SPRTN_3_LSTG');
872: commit;

Line 879: End EDW_HR_MVMNT_TYP_M_C;

875: Exception When others then
876: raise;
877: commit;
878: END;
879: End EDW_HR_MVMNT_TYP_M_C;