APPS.EDW_OPI_ACTV_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: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
28: Return;
29: END IF;

Line 32: EDW_OPI_ACTV_M_C.g_push_date_range1 := EDW_COLLECTION_UTIL.G_local_last_push_start_date -

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

Line 33: EDW_COLLECTION_UTIL.g_offset;

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

Line 39: EDW_OPI_ACTV_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

35: EDW_OPI_ACTV_M_C.g_push_date_range1 := to_date(p_from_date, 'YYYY/MM/DD HH24:MI:SS');
36: END IF;
37:
38: IF (p_to_date IS NULL) THEN
39: EDW_OPI_ACTV_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
40: ELSE
41: /* Bug 2333020
42: IF to_char(to_date(p_to_date,'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD') = to_char(sysdate,'YYYY/MM/DD') THEN
43: EDW_OPI_ACTV_M_C.g_push_date_range2 := to_date(to_char(sysdate, 'YYYY/MM/DD HH24:MI:SS'),'YYYY/MM/DD HH24:MI:SS');

Line 79: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,

75: edw_log.put_line(' ');
76: -- ---------------------------------------------------------------------------
77: -- END OF Collection , Developer Customizable Section
78: -- ---------------------------------------------------------------------------
79: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,
80: EDW_OPI_ACTV_M_C.g_exception_msg,
81: edw_opi_actv_m_c.g_push_date_range1,
82: EDW_OPI_ACTV_M_C.g_push_date_range2);
83: commit;

Line 91: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_ACTV_M_C.g_exception_msg,

87: Retcode:=sqlcode;
88: l_exception_msg := Retcode || ':' || Errbuf;
89: EDW_OPI_ACTV_M_C.g_exception_msg := l_exception_msg;
90: rollback;
91: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_ACTV_M_C.g_exception_msg,
92: edw_opi_actv_m_c.g_push_date_range1,
93: EDW_OPI_ACTV_M_C.g_push_date_range2);
94:
95: commit;