APPS.HR_EDW_WRK_ACTVTY_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_ACTVTY_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_ACTVTY_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_ACTVTY_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_ACTVTY_F_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

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

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

327:
328: -- ---------------------------------------------------------------------------
329: -- END OF Collection , Developer Customizable Section
330: -- ---------------------------------------------------------------------------
331: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count, null, l_date1, l_date2);
332:
333: Exception When others then
334: Errbuf:=sqlerrm;
335: Retcode:=sqlcode;

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

334: Errbuf:=sqlerrm;
335: Retcode:=sqlcode;
336: l_exception_msg := Retcode || ':' || Errbuf;
337: rollback;
338: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, l_exception_msg, l_date1, l_date2);
339: raise;
340:
341: End;
342: End HR_EDW_WRK_ACTVTY_F_C;