APPS.EDW_POA_LN_TYPE_M_C dependencies on EDW_COLLECTION_UTIL

Line 23: If (Not EDW_COLLECTION_UTIL.setup(l_dimension_name)) Then

19: BEGIN
20: Errbuf := NULL;
21: Retcode := 0;
22:
23: If (Not EDW_COLLECTION_UTIL.setup(l_dimension_name)) Then
24: errbuf := fnd_message.get;
25: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
26: End If;
27:

Line 32: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

28: l_from_date := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
29: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
30:
31: l_push_date_range1 := nvl(l_from_date,
32: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
33: l_push_date_range2 := nvl(l_to_date, EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
34: edw_log.put_line( 'The collection range is from '||
35: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
36: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

Line 33: l_push_date_range2 := nvl(l_to_date, EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

29: l_to_date := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
30:
31: l_push_date_range1 := nvl(l_from_date,
32: EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
33: l_push_date_range2 := nvl(l_to_date, EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
34: edw_log.put_line( 'The collection range is from '||
35: to_char(l_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
36: to_char(l_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
37: edw_log.put_line(' ');

Line 42: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,

38:
39: Edw_POA_LN_TYPE_M_C.Push_LN_TYPE(Errbuf, Retcode, L_push_date_range1,l_push_date_range2);
40:
41:
42: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,
43: P_PERIOD_START => l_push_date_range1,
44: P_PERIOD_END => l_push_date_range2);
45: commit;
46:

Line 52: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_POA_LN_TYPE_M_C.g_exception_message,

48: Errbuf := sqlerrm;
49: Retcode := sqlcode;
50: EDW_POA_LN_TYPE_M_C.g_exception_message := EDW_POA_LN_TYPE_M_C.g_exception_message||'<>
51: '||Retcode || ':' || Errbuf;
52: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_POA_LN_TYPE_M_C.g_exception_message,
53: l_push_date_range1, l_push_date_range2);
54: rollback;
55: raise;
56: