APPS.EDW_OPI_LOT_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_LOT_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_LOT_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_LOT_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_LOT_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_LOT_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_LOT_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;

35: EDW_OPI_LOT_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_LOT_M_C.g_push_date_range2 := EDW_COLLECTION_UTIL.G_local_curr_push_start_date;
40: ELSE
41: EDW_OPI_LOT_M_C.g_push_date_range2 := to_date(p_to_date, 'YYYY/MM/DD HH24:MI:SS');
42: END IF;
43:

Line 71: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_LOT_M_C.g_exception_msg,

67: edw_log.put_line(' ');
68: -- ---------------------------------------------------------------------------
69: -- END OF Collection , Developer Customizable Section
70: -- ---------------------------------------------------------------------------
71: EDW_COLLECTION_UTIL.wrapup(TRUE, g_row_count,EDW_OPI_LOT_M_C.g_exception_msg,
72: EDW_OPI_LOT_M_C.g_push_date_range1,
73: EDW_OPI_LOT_M_C.g_push_date_range2);
74: commit;
75:

Line 82: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_LOT_M_C.g_exception_msg,

78: Retcode:=sqlcode;
79: l_exception_msg := Retcode || ':' || Errbuf;
80: EDW_OPI_LOT_M_C.g_exception_msg := l_exception_msg;
81: rollback;
82: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_OPI_LOT_M_C.g_exception_msg,
83: EDW_OPI_LOT_M_C.g_push_date_range1,
84: EDW_OPI_LOT_M_C.g_push_date_range2);
85: commit;
86: End;