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_RQN_VCNCY_M_C dependencies on EDW_HR_RQN_VCNCY_M_C

Line 1: Package Body EDW_HR_RQN_VCNCY_M_C AS

1: Package Body EDW_HR_RQN_VCNCY_M_C AS
2: /* $Header: hriepvac.pkb 120.1 2005/06/07 06:04:28 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_RQN_VCNCY_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_RQN_VCNCY_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_RQN_VCNCY_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
35: END IF;

Line 34: EDW_HR_RQN_VCNCY_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_RQN_VCNCY_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_RQN_VCNCY_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_RQN_VCNCY_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

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

34: EDW_HR_RQN_VCNCY_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_RQN_VCNCY_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
39: ELSE
40: EDW_HR_RQN_VCNCY_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_RQN_VCNCY_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_RQN_VCNCY_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
39: ELSE
40: EDW_HR_RQN_VCNCY_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_RQN_VCNCY_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_RQN_VCNCY_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_RQN_VCNCY_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_RQN_VCNCY_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_RQN_VCNCY_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
46: to_char(EDW_HR_RQN_VCNCY_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_RQVC_VACANCY_LSTG(EDW_HR_RQN_VCNCY_M_C.g_push_date_range1, EDW_HR_RQN_VCNCY_M_C.g_push_date_range2);

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

Line 60: Push_EDW_HR_RQVC_REQUISTN_LSTG(EDW_HR_RQN_VCNCY_M_C.g_push_date_range1, EDW_HR_RQN_VCNCY_M_C.g_push_date_range2);

56: l_temp_date := sysdate;
57:
58:
59: Push_EDW_HR_RQVC_VACANCY_LSTG(EDW_HR_RQN_VCNCY_M_C.g_push_date_range1, EDW_HR_RQN_VCNCY_M_C.g_push_date_range2);
60: Push_EDW_HR_RQVC_REQUISTN_LSTG(EDW_HR_RQN_VCNCY_M_C.g_push_date_range1, EDW_HR_RQN_VCNCY_M_C.g_push_date_range2);
61:
62:
63: l_duration := sysdate - l_temp_date;
64:

Line 78: EDW_HR_RQN_VCNCY_M_C.g_exception_msg := l_exception_msg;

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

Line 80: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_RQN_VCNCY_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);

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

Line 151: EDW_HR_RQN_VCNCY_M_C.g_row_count := EDW_HR_RQN_VCNCY_M_C.g_row_count + l_rows_inserted ;

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

Line 225: End EDW_HR_RQN_VCNCY_M_C;

221: Exception When others then
222: raise;
223: commit;
224: END;
225: End EDW_HR_RQN_VCNCY_M_C;