DBA Data[Home] [Help]

APPS.HR_EDW_WRK_RCTMNT_F_C dependencies on EDW_COLLECTION_UTIL

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

21: -- -------------------------------------------
22: Begin
23: Errbuf :=NULL;
24: Retcode:=0;
25: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name)) THEN
26: errbuf := fnd_message.get;
27: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
28: Return;
29: END IF;

Line 32: HR_EDW_WRK_RCTMNT_F_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset;

28: Return;
29: END IF;
30:
31: IF (p_from_date IS NULL) THEN
32: HR_EDW_WRK_RCTMNT_F_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset;
33: ELSE
34: HR_EDW_WRK_RCTMNT_F_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
35: END IF;
36:

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

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

Line 309: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, l_date1, l_date2);

305:
306: -- ---------------------------------------------------------------------------
307: -- END OF Collection , Developer Customizable Section
308: -- ---------------------------------------------------------------------------
309: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, l_date1, l_date2);
310:
311: Exception When others then
312: Errbuf:=sqlerrm;
313: Retcode:=sqlcode;

Line 316: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, l_date1, l_date2);

312: Errbuf:=sqlerrm;
313: Retcode:=sqlcode;
314: l_exception_msg := Retcode || ':' || Errbuf;
315: rollback;
316: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, l_date1, l_date2);
317: raise;
318:
319: End;
320: End HR_EDW_WRK_RCTMNT_F_C;