APPS.EDW_HR_SERVICE_M_C dependencies on EDW_HR_SERVICE_M_C

Line 1: Package Body EDW_HR_SERVICE_M_C AS

1: Package Body EDW_HR_SERVICE_M_C AS
2: /* $Header: hrieplwb.pkb 120.1 2005/06/07 05:54:10 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_SERVICE_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_SERVICE_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_SERVICE_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
35: END IF;

Line 34: EDW_HR_SERVICE_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_SERVICE_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_SERVICE_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_SERVICE_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

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

34: EDW_HR_SERVICE_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_SERVICE_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
39: ELSE
40: EDW_HR_SERVICE_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_SERVICE_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_SERVICE_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
39: ELSE
40: EDW_HR_SERVICE_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_SERVICE_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_SERVICE_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_SERVICE_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_SERVICE_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_SERVICE_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_SERVICE_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_SRVC_SRV_BAND_LSTG(EDW_HR_SERVICE_M_C.g_push_date_range1, EDW_HR_SERVICE_M_C.g_push_date_range2);

55:
56: l_temp_date := sysdate;
57:
58:
59: Push_EDW_HR_SRVC_SRV_BAND_LSTG(EDW_HR_SERVICE_M_C.g_push_date_range1, EDW_HR_SERVICE_M_C.g_push_date_range2);
60:
61:
62: l_duration := sysdate - l_temp_date;
63:

Line 77: EDW_HR_SERVICE_M_C.g_exception_msg := l_exception_msg;

73: Exception When others then
74: Errbuf:=sqlerrm;
75: Retcode:=sqlcode;
76: l_exception_msg := Retcode || ':' || Errbuf;
77: EDW_HR_SERVICE_M_C.g_exception_msg := l_exception_msg;
78: rollback;
79: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_SERVICE_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);
80:
81: commit;

Line 79: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_SERVICE_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);

75: Retcode:=sqlcode;
76: l_exception_msg := Retcode || ':' || Errbuf;
77: EDW_HR_SERVICE_M_C.g_exception_msg := l_exception_msg;
78: rollback;
79: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_SERVICE_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);
80:
81: commit;
82: End;
83:

Line 144: EDW_HR_SERVICE_M_C.g_row_count := EDW_HR_SERVICE_M_C.g_row_count + l_rows_inserted ;

140: where last_update_date between l_date1 and l_date2;
141:
142:
143: l_rows_inserted := sql%rowcount;
144: EDW_HR_SERVICE_M_C.g_row_count := EDW_HR_SERVICE_M_C.g_row_count + l_rows_inserted ;
145: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
146: ' rows into the EDW_HR_SRVC_SRV_BAND_LSTG staging table');
147: edw_log.put_line('Commiting records for EDW_HR_SRVC_SRV_BAND_LSTG');
148: commit;

Line 155: End EDW_HR_SERVICE_M_C;

151: Exception When others then
152: raise;
153: commit;
154: END;
155: End EDW_HR_SERVICE_M_C;