1: Package Body EDW_HR_PRSN_TYP_M_C AS
2: /* $Header: hrieppty.pkb 120.2 2006/04/06 02:23:23 jtitmas noship $ */
3: G_PUSH_DATE_RANGE1 Date:=Null;
4: G_PUSH_DATE_RANGE2 Date:=Null;
5: g_row_count Number:=0;
27: Return;
28: END IF;
29:
30: IF (p_from_date IS NULL) THEN
31: EDW_HR_PRSN_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_PRSN_TYP_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
35: END IF;
30: IF (p_from_date IS NULL) THEN
31: EDW_HR_PRSN_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_PRSN_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_PRSN_TYP_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
34: EDW_HR_PRSN_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_PRSN_TYP_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
39: ELSE
40: EDW_HR_PRSN_TYP_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
41: END IF;
42:
36:
37: IF (p_to_date IS NULL) THEN
38: EDW_HR_PRSN_TYP_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
39: ELSE
40: EDW_HR_PRSN_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 '||
41: END IF;
42:
43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_HR_PRSN_TYP_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_PRSN_TYP_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
47: edw_log.put_line(' ');
48:
49: -- -----------------------------------------------------------------------------
42:
43:
44: edw_log.put_line( 'The collection range is from '||
45: to_char(EDW_HR_PRSN_TYP_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_PRSN_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
60:
61: l_temp_date := sysdate;
62:
63:
64: Push_EDW_HR_PTYP_PRSN_TYP_LSTG(EDW_HR_PRSN_TYP_M_C.g_push_date_range1, EDW_HR_PRSN_TYP_M_C.g_push_date_range2);
65:
66:
67: l_duration := sysdate - l_temp_date;
68:
78: Exception When others then
79: Errbuf:=sqlerrm;
80: Retcode:=sqlcode;
81: l_exception_msg := Retcode || ':' || Errbuf;
82: EDW_HR_PRSN_TYP_M_C.g_exception_msg := l_exception_msg;
83: rollback;
84: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_PRSN_TYP_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);
85:
86: commit;
80: Retcode:=sqlcode;
81: l_exception_msg := Retcode || ':' || Errbuf;
82: EDW_HR_PRSN_TYP_M_C.g_exception_msg := l_exception_msg;
83: rollback;
84: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_PRSN_TYP_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);
85:
86: commit;
87: End;
88:
226: where last_update_date between l_date1 and sysdate;
227:
228:
229: l_rows_inserted := sql%rowcount;
230: EDW_HR_PRSN_TYP_M_C.g_row_count := EDW_HR_PRSN_TYP_M_C.g_row_count + l_rows_inserted ;
231: edw_log.put_line('Inserted '||to_char(nvl(sql%rowcount,0))||
232: ' rows into the EDW_HR_PTYP_PRSN_TYP_LSTG staging table');
233: edw_log.put_line('Commiting records for EDW_HR_PTYP_PRSN_TYP_LSTG');
234: commit;
237: Exception When others then
238: raise;
239: commit;
240: END;
241: End EDW_HR_PRSN_TYP_M_C;