APPS.EDW_HR_REC_ACT_M_C dependencies on EDW_COLLECTION_UTIL

Line 25: IF (Not EDW_COLLECTION_UTIL.setup(l_dimension_name)) THEN

21: -- -------------------------------------------
22: Begin
23: Errbuf :=NULL;
24: Retcode:=0;
25: IF (Not EDW_COLLECTION_UTIL.setup(l_dimension_name)) THEN
26: errbuf := fnd_message.get;
27: Return;
28: END IF;
29:

Line 31: EDW_HR_REC_ACT_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_REC_ACT_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_REC_ACT_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
35: END IF;

Line 32: EDW_COLLECTION_UTIL.g_offset;

28: END IF;
29:
30: IF (p_from_date IS NULL) THEN
31: EDW_HR_REC_ACT_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_REC_ACT_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
35: END IF;
36:

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

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

Line 71: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2 );

67: edw_log.put_line(' ');
68: -- ---------------------------------------------------------------------------
69: -- END OF Collection , Developer Customizable Section
70: -- ---------------------------------------------------------------------------
71: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, g_push_date_range1, g_push_date_range2 );
72: commit;
73:
74: Exception When others then
75: Errbuf:=sqlerrm;

Line 80: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_REC_ACT_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_REC_ACT_M_C.g_exception_msg := l_exception_msg;
79: rollback;
80: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_REC_ACT_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);
81:
82: commit;
83: End;
84: