APPS.EDW_HR_PRSN_TYP_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_PRSN_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_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;

Line 32: EDW_COLLECTION_UTIL.g_offset;

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;
36:

Line 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:

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

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

Line 84: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_HR_PRSN_TYP_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);

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: