APPS.EDW_FLEX_PUSH_C dependencies on EDW_FLEX_PUSH_C

Line 1: Package Body EDW_FLEX_PUSH_C AS

1: Package Body EDW_FLEX_PUSH_C AS
2: /* $Header: EDWFLXGB.pls 115.7 2002/12/05 23:05:17 arsantha ship $ */
3: G_DIMENSION VARCHAR2(100);
4: G_INDEX NUMBER := 0;
5: G_PUSH_DATE_RANGE1 Date:=Null;

Line 73: to_char(EDW_FLEX_PUSH_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||

69: END IF;
70:
71: edw_log.put_line( 'Push for User Defined dimension : '||p_dimension);
72: edw_log.put_line( 'The push range is from '||
73: to_char(EDW_FLEX_PUSH_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
74: to_char(EDW_FLEX_PUSH_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
75: edw_log.put_line(' ');
76:
77: -- -----------------------------------------------------------------------------

Line 74: to_char(EDW_FLEX_PUSH_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));

70:
71: edw_log.put_line( 'Push for User Defined dimension : '||p_dimension);
72: edw_log.put_line( 'The push range is from '||
73: to_char(EDW_FLEX_PUSH_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
74: to_char(EDW_FLEX_PUSH_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
75: edw_log.put_line(' ');
76:
77: -- -----------------------------------------------------------------------------
78: -- Start of Collection , Developer Customizable Section

Line 104: EDW_FLEX_PUSH_C.g_exception_msg := l_exception_msg;

100: Exception When others then
101: Errbuf:=sqlerrm;
102: Retcode:=sqlcode;
103: l_exception_msg := Retcode || ':' || Errbuf;
104: EDW_FLEX_PUSH_C.g_exception_msg := l_exception_msg;
105: rollback;
106: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_FLEX_PUSH_C.g_exception_msg,
107: g_push_date_range1, g_push_date_range2);
108:

Line 106: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_FLEX_PUSH_C.g_exception_msg,

102: Retcode:=sqlcode;
103: l_exception_msg := Retcode || ':' || Errbuf;
104: EDW_FLEX_PUSH_C.g_exception_msg := l_exception_msg;
105: rollback;
106: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, EDW_FLEX_PUSH_C.g_exception_msg,
107: g_push_date_range1, g_push_date_range2);
108:
109: commit;
110: End;

Line 184: End EDW_FLEX_PUSH_C;

180: Push_One_Level(p_from_date, p_to_date, 1); /* Higher level push */
181: END;
182:
183:
184: End EDW_FLEX_PUSH_C;