APPS.FII_TIME_M_C dependencies on FII_TIME_M_C

Line 1: Package Body FII_TIME_M_C AS

1: Package Body FII_TIME_M_C AS
2: /* $Header: FIICMCAB.pls 120.3 2004/11/22 17:44:03 phu ship $ */
3:
4: c_from_date Date:=Null;
5: c_to_date Date:=Null;

Line 36: FII_TIME_M_C.g_push_date_range1 := nvl(l_from_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

32:
33: Return;
34: END IF;
35:
36: FII_TIME_M_C.g_push_date_range1 := nvl(l_from_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
37:
38: FII_TIME_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
39:
40: edw_log.put_line(' ');

Line 38: FII_TIME_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

34: END IF;
35:
36: FII_TIME_M_C.g_push_date_range1 := nvl(l_from_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
37:
38: FII_TIME_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
39:
40: edw_log.put_line(' ');
41: edw_log.put_line('Pushing GL calendar and Enterprise calendar');
42:

Line 44: to_char(FII_TIME_M_C.g_push_date_range1,'dd-MON-yyyy')||' to '||

40: edw_log.put_line(' ');
41: edw_log.put_line('Pushing GL calendar and Enterprise calendar');
42:
43: edw_log.put_line( 'The collection range is from '||
44: to_char(FII_TIME_M_C.g_push_date_range1,'dd-MON-yyyy')||' to '||
45: to_char(FII_TIME_M_C.g_push_date_range2,'dd-MON-yyyy'));
46:
47: -- -----------------------------------------------------------------------------
48: -- Start to push data into staging table

Line 45: to_char(FII_TIME_M_C.g_push_date_range2,'dd-MON-yyyy'));

41: edw_log.put_line('Pushing GL calendar and Enterprise calendar');
42:
43: edw_log.put_line( 'The collection range is from '||
44: to_char(FII_TIME_M_C.g_push_date_range1,'dd-MON-yyyy')||' to '||
45: to_char(FII_TIME_M_C.g_push_date_range2,'dd-MON-yyyy'));
46:
47: -- -----------------------------------------------------------------------------
48: -- Start to push data into staging table
49: -- -----------------------------------------------------------------------------

Line 56: Push_gl_and_ent_calendar(FII_TIME_M_C.g_push_date_range1, FII_TIME_M_C.g_push_date_range2);

52:
53: edw_log.put_line(' ');
54: l_temp_date := sysdate;
55:
56: Push_gl_and_ent_calendar(FII_TIME_M_C.g_push_date_range1, FII_TIME_M_C.g_push_date_range2);
57:
58: l_duration := sysdate - l_temp_date;
59: edw_log.put_line('GL calendar and Enterprise calendar has been pushed successfully!');
60: edw_log.put_line('Process Time: '||edw_log.duration(l_duration));

Line 78: FII_TIME_M_C.g_push_date_range1, FII_TIME_M_C.g_push_date_range2);

74:
75: g_rows_inserted:=g_rows_inserted+rows_inserted;
76:
77: EDW_COLLECTION_UTIL.wrapup(TRUE, g_rows_inserted, null,
78: FII_TIME_M_C.g_push_date_range1, FII_TIME_M_C.g_push_date_range2);
79:
80: commit;
81:
82: Exception When others then

Line 87: FII_TIME_M_C.g_exception_msg := l_exception_msg;

83:
84: Errbuf:=sqlerrm;
85: Retcode:=sqlcode;
86: l_exception_msg := Retcode || ':' || Errbuf;
87: FII_TIME_M_C.g_exception_msg := l_exception_msg;
88: rollback;
89:
90: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_TIME_M_C.g_exception_msg,
91: FII_TIME_M_C.g_push_date_range1, FII_TIME_M_C.g_push_date_range2);

Line 90: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_TIME_M_C.g_exception_msg,

86: l_exception_msg := Retcode || ':' || Errbuf;
87: FII_TIME_M_C.g_exception_msg := l_exception_msg;
88: rollback;
89:
90: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_TIME_M_C.g_exception_msg,
91: FII_TIME_M_C.g_push_date_range1, FII_TIME_M_C.g_push_date_range2);
92:
93: END Push;
94:

Line 91: FII_TIME_M_C.g_push_date_range1, FII_TIME_M_C.g_push_date_range2);

87: FII_TIME_M_C.g_exception_msg := l_exception_msg;
88: rollback;
89:
90: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_TIME_M_C.g_exception_msg,
91: FII_TIME_M_C.g_push_date_range1, FII_TIME_M_C.g_push_date_range2);
92:
93: END Push;
94:
95:

Line 1327: END FII_TIME_M_C;

1323: raise;
1324:
1325: END Push_gl_and_ent_calendar;
1326:
1327: END FII_TIME_M_C;