eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FII_PROJECT_M_C dependencies on FII_PROJECT_M_C

Line 1: Package Body FII_PROJECT_M_C AS

1: Package Body FII_PROJECT_M_C AS
2: /* $Header: FIICMPJB.pls 120.2 2005/06/07 14:59:07 pschandr ship $ */
3:
4: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('FII_DEBUG_MODE'), 'N');
5:

Line 42: FII_PROJECT_M_C.g_push_date_range1 := nvl(l_from_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);

38: errbuf := fnd_message.get;
39: raise_application_error(-20000,'Error in SETUP: ' || errbuf);
40: END IF;
41:
42: FII_PROJECT_M_C.g_push_date_range1 := nvl(l_from_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
43: FII_PROJECT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
44:
45: if g_debug_flag = 'Y' then
46: edw_log.put_line( 'The collection range is from '||

Line 43: FII_PROJECT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);

39: raise_application_error(-20000,'Error in SETUP: ' || errbuf);
40: END IF;
41:
42: FII_PROJECT_M_C.g_push_date_range1 := nvl(l_from_date,EDW_COLLECTION_UTIL.G_local_last_push_start_date - EDW_COLLECTION_UTIL.g_offset);
43: FII_PROJECT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
44:
45: if g_debug_flag = 'Y' then
46: edw_log.put_line( 'The collection range is from '||
47: to_char(FII_PROJECT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||

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

43: FII_PROJECT_M_C.g_push_date_range2 := nvl(l_to_date,EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
44:
45: if g_debug_flag = 'Y' then
46: edw_log.put_line( 'The collection range is from '||
47: to_char(FII_PROJECT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
48: to_char(FII_PROJECT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
49: edw_log.put_line(' ');
50: end if;
51:

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

44:
45: if g_debug_flag = 'Y' then
46: edw_log.put_line( 'The collection range is from '||
47: to_char(FII_PROJECT_M_C.g_push_date_range1,'MM/DD/YYYY HH24:MI:SS')||' to '||
48: to_char(FII_PROJECT_M_C.g_push_date_range2,'MM/DD/YYYY HH24:MI:SS'));
49: edw_log.put_line(' ');
50: end if;
51:
52: -- -----------------------------------------------------------------------------

Line 63: Push_EDW_PROJ_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

59: end if;
60:
61: l_temp_date := sysdate;
62:
63: Push_EDW_PROJ_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
64: Push_EDW_PROJ_TOP_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
65: Push_EDW_PROJ_PROJECT_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
66: Push_EDW_PROJ_PRJ_TYP_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
67: Push_EDW_PROJ_CLS1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 64: Push_EDW_PROJ_TOP_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

60:
61: l_temp_date := sysdate;
62:
63: Push_EDW_PROJ_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
64: Push_EDW_PROJ_TOP_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
65: Push_EDW_PROJ_PROJECT_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
66: Push_EDW_PROJ_PRJ_TYP_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
67: Push_EDW_PROJ_CLS1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
68: Push_EDW_PROJ_CLS2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 65: Push_EDW_PROJ_PROJECT_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

61: l_temp_date := sysdate;
62:
63: Push_EDW_PROJ_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
64: Push_EDW_PROJ_TOP_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
65: Push_EDW_PROJ_PROJECT_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
66: Push_EDW_PROJ_PRJ_TYP_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
67: Push_EDW_PROJ_CLS1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
68: Push_EDW_PROJ_CLS2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
69: Push_EDW_PROJ_CLS3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 66: Push_EDW_PROJ_PRJ_TYP_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

62:
63: Push_EDW_PROJ_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
64: Push_EDW_PROJ_TOP_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
65: Push_EDW_PROJ_PROJECT_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
66: Push_EDW_PROJ_PRJ_TYP_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
67: Push_EDW_PROJ_CLS1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
68: Push_EDW_PROJ_CLS2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
69: Push_EDW_PROJ_CLS3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
70: Push_EDW_PROJ_CLS4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 67: Push_EDW_PROJ_CLS1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

63: Push_EDW_PROJ_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
64: Push_EDW_PROJ_TOP_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
65: Push_EDW_PROJ_PROJECT_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
66: Push_EDW_PROJ_PRJ_TYP_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
67: Push_EDW_PROJ_CLS1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
68: Push_EDW_PROJ_CLS2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
69: Push_EDW_PROJ_CLS3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
70: Push_EDW_PROJ_CLS4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
71: Push_EDW_PROJ_CLS5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 68: Push_EDW_PROJ_CLS2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

64: Push_EDW_PROJ_TOP_TASK_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
65: Push_EDW_PROJ_PROJECT_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
66: Push_EDW_PROJ_PRJ_TYP_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
67: Push_EDW_PROJ_CLS1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
68: Push_EDW_PROJ_CLS2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
69: Push_EDW_PROJ_CLS3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
70: Push_EDW_PROJ_CLS4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
71: Push_EDW_PROJ_CLS5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
72: Push_EDW_PROJ_CLS6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 69: Push_EDW_PROJ_CLS3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

65: Push_EDW_PROJ_PROJECT_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
66: Push_EDW_PROJ_PRJ_TYP_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
67: Push_EDW_PROJ_CLS1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
68: Push_EDW_PROJ_CLS2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
69: Push_EDW_PROJ_CLS3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
70: Push_EDW_PROJ_CLS4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
71: Push_EDW_PROJ_CLS5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
72: Push_EDW_PROJ_CLS6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
73: Push_EDW_PROJ_CLS7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 70: Push_EDW_PROJ_CLS4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

66: Push_EDW_PROJ_PRJ_TYP_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
67: Push_EDW_PROJ_CLS1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
68: Push_EDW_PROJ_CLS2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
69: Push_EDW_PROJ_CLS3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
70: Push_EDW_PROJ_CLS4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
71: Push_EDW_PROJ_CLS5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
72: Push_EDW_PROJ_CLS6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
73: Push_EDW_PROJ_CLS7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
74: Push_EDW_PROJ_CATEG1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 71: Push_EDW_PROJ_CLS5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

67: Push_EDW_PROJ_CLS1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
68: Push_EDW_PROJ_CLS2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
69: Push_EDW_PROJ_CLS3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
70: Push_EDW_PROJ_CLS4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
71: Push_EDW_PROJ_CLS5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
72: Push_EDW_PROJ_CLS6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
73: Push_EDW_PROJ_CLS7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
74: Push_EDW_PROJ_CATEG1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
75: Push_EDW_PROJ_CATEG2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 72: Push_EDW_PROJ_CLS6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

68: Push_EDW_PROJ_CLS2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
69: Push_EDW_PROJ_CLS3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
70: Push_EDW_PROJ_CLS4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
71: Push_EDW_PROJ_CLS5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
72: Push_EDW_PROJ_CLS6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
73: Push_EDW_PROJ_CLS7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
74: Push_EDW_PROJ_CATEG1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
75: Push_EDW_PROJ_CATEG2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
76: Push_EDW_PROJ_CATEG3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 73: Push_EDW_PROJ_CLS7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

69: Push_EDW_PROJ_CLS3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
70: Push_EDW_PROJ_CLS4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
71: Push_EDW_PROJ_CLS5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
72: Push_EDW_PROJ_CLS6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
73: Push_EDW_PROJ_CLS7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
74: Push_EDW_PROJ_CATEG1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
75: Push_EDW_PROJ_CATEG2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
76: Push_EDW_PROJ_CATEG3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
77: Push_EDW_PROJ_CATEG4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 74: Push_EDW_PROJ_CATEG1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

70: Push_EDW_PROJ_CLS4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
71: Push_EDW_PROJ_CLS5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
72: Push_EDW_PROJ_CLS6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
73: Push_EDW_PROJ_CLS7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
74: Push_EDW_PROJ_CATEG1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
75: Push_EDW_PROJ_CATEG2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
76: Push_EDW_PROJ_CATEG3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
77: Push_EDW_PROJ_CATEG4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
78: Push_EDW_PROJ_CATEG5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 75: Push_EDW_PROJ_CATEG2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

71: Push_EDW_PROJ_CLS5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
72: Push_EDW_PROJ_CLS6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
73: Push_EDW_PROJ_CLS7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
74: Push_EDW_PROJ_CATEG1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
75: Push_EDW_PROJ_CATEG2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
76: Push_EDW_PROJ_CATEG3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
77: Push_EDW_PROJ_CATEG4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
78: Push_EDW_PROJ_CATEG5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
79: Push_EDW_PROJ_CATEG6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 76: Push_EDW_PROJ_CATEG3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

72: Push_EDW_PROJ_CLS6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
73: Push_EDW_PROJ_CLS7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
74: Push_EDW_PROJ_CATEG1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
75: Push_EDW_PROJ_CATEG2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
76: Push_EDW_PROJ_CATEG3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
77: Push_EDW_PROJ_CATEG4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
78: Push_EDW_PROJ_CATEG5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
79: Push_EDW_PROJ_CATEG6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
80: Push_EDW_PROJ_CATEG7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

Line 77: Push_EDW_PROJ_CATEG4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

73: Push_EDW_PROJ_CLS7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
74: Push_EDW_PROJ_CATEG1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
75: Push_EDW_PROJ_CATEG2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
76: Push_EDW_PROJ_CATEG3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
77: Push_EDW_PROJ_CATEG4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
78: Push_EDW_PROJ_CATEG5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
79: Push_EDW_PROJ_CATEG6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
80: Push_EDW_PROJ_CATEG7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
81:

Line 78: Push_EDW_PROJ_CATEG5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

74: Push_EDW_PROJ_CATEG1_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
75: Push_EDW_PROJ_CATEG2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
76: Push_EDW_PROJ_CATEG3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
77: Push_EDW_PROJ_CATEG4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
78: Push_EDW_PROJ_CATEG5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
79: Push_EDW_PROJ_CATEG6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
80: Push_EDW_PROJ_CATEG7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
81:
82: l_duration := sysdate - l_temp_date;

Line 79: Push_EDW_PROJ_CATEG6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

75: Push_EDW_PROJ_CATEG2_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
76: Push_EDW_PROJ_CATEG3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
77: Push_EDW_PROJ_CATEG4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
78: Push_EDW_PROJ_CATEG5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
79: Push_EDW_PROJ_CATEG6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
80: Push_EDW_PROJ_CATEG7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
81:
82: l_duration := sysdate - l_temp_date;
83:

Line 80: Push_EDW_PROJ_CATEG7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);

76: Push_EDW_PROJ_CATEG3_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
77: Push_EDW_PROJ_CATEG4_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
78: Push_EDW_PROJ_CATEG5_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
79: Push_EDW_PROJ_CATEG6_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
80: Push_EDW_PROJ_CATEG7_LSTG(FII_PROJECT_M_C.g_push_date_range1, FII_PROJECT_M_C.g_push_date_range2);
81:
82: l_duration := sysdate - l_temp_date;
83:
84: if g_debug_flag = 'Y' then

Line 104: FII_PROJECT_M_C.g_exception_msg := l_exception_msg;

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

Line 108: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_PROJECT_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);

104: FII_PROJECT_M_C.g_exception_msg := l_exception_msg;
105:
106: rollback;
107:
108: EDW_COLLECTION_UTIL.wrapup(FALSE, 0, FII_PROJECT_M_C.g_exception_msg, g_push_date_range1, g_push_date_range2);
109:
110: commit;
111:
112: End;

Line 360: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

356: where
357: last_update_date between l_date1 and l_date2;
358:
359: l_rows_inserted := sql%rowcount;
360: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
361:
362: if g_debug_flag = 'Y' then
363: edw_log.put_line('Commiting records for EDW_PROJ_PROJECT_LSTG');
364: end if;

Line 492: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

488: l_rows_inserted := l_rows_inserted + 1;
489:
490: end if;
491:
492: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
493:
494: if g_debug_flag = 'Y' then
495: edw_log.put_line('Commiting records for EDW_PROJ_PRJ_TYP_LSTG');
496: end if;

Line 564: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

560: where
561: last_update_date between l_date1 and l_date2;
562:
563: l_rows_inserted := sql%rowcount;
564: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
565:
566: if g_debug_flag = 'Y' then
567: edw_log.put_line('Commiting records for EDW_PROJ_CLS1_LSTG');
568: end if;

Line 635: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

631: where
632: last_update_date between l_date1 and l_date2;
633:
634: l_rows_inserted := sql%rowcount;
635: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
636:
637: if g_debug_flag = 'Y' then
638: edw_log.put_line('Commiting records for EDW_PROJ_CLS2_LSTG');
639: end if;

Line 707: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

703: where
704: last_update_date between l_date1 and l_date2;
705:
706: l_rows_inserted := sql%rowcount;
707: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
708:
709: if g_debug_flag = 'Y' then
710: edw_log.put_line('Commiting records for EDW_PROJ_CLS3_LSTG');
711: end if;

Line 779: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

775: where
776: last_update_date between l_date1 and l_date2;
777:
778: l_rows_inserted := sql%rowcount;
779: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
780:
781: if g_debug_flag = 'Y' then
782: edw_log.put_line('Commiting records for EDW_PROJ_CLS4_LSTG');
783: end if;

Line 851: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

847: where
848: last_update_date between l_date1 and l_date2;
849:
850: l_rows_inserted := sql%rowcount;
851: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
852:
853: if g_debug_flag = 'Y' then
854: edw_log.put_line('Commiting records for EDW_PROJ_CLS5_LSTG');
855: end if;

Line 923: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

919: where
920: last_update_date between l_date1 and l_date2;
921:
922: l_rows_inserted := sql%rowcount;
923: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
924:
925: if g_debug_flag = 'Y' then
926: edw_log.put_line('Commiting records for EDW_PROJ_CLS6_LSTG');
927: end if;

Line 995: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

991: where
992: last_update_date between l_date1 and l_date2;
993:
994: l_rows_inserted := sql%rowcount;
995: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
996:
997: if g_debug_flag = 'Y' then
998: edw_log.put_line('Commiting records for EDW_PROJ_CLS7_LSTG');
999: end if;

Line 1067: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

1063: where
1064: last_update_date between l_date1 and l_date2;
1065:
1066: l_rows_inserted := sql%rowcount;
1067: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1068:
1069: if g_debug_flag = 'Y' then
1070: edw_log.put_line('Commiting records for EDW_PROJ_CATEG1_LSTG');
1071: end if;

Line 1139: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

1135: where
1136: last_update_date between l_date1 and l_date2;
1137:
1138: l_rows_inserted := sql%rowcount;
1139: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1140:
1141: if g_debug_flag = 'Y' then
1142: edw_log.put_line('Commiting records for EDW_PROJ_CATEG2_LSTG');
1143: end if;

Line 1210: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

1206: where
1207: last_update_date between l_date1 and l_date2;
1208:
1209: l_rows_inserted := sql%rowcount;
1210: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1211:
1212: if g_debug_flag = 'Y' then
1213: edw_log.put_line('Commiting records for EDW_PROJ_CATEG3_LSTG');
1214: end if;

Line 1282: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

1278: where
1279: last_update_date between l_date1 and l_date2;
1280:
1281: l_rows_inserted := sql%rowcount;
1282: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1283:
1284: if g_debug_flag = 'Y' then
1285: edw_log.put_line('Commiting records for EDW_PROJ_CATEG4_LSTG');
1286: end if;

Line 1354: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

1350: where
1351: last_update_date between l_date1 and l_date2;
1352:
1353: l_rows_inserted := sql%rowcount;
1354: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1355:
1356: if g_debug_flag = 'Y' then
1357: edw_log.put_line('Commiting records for EDW_PROJ_CATEG5_LSTG');
1358: end if;

Line 1426: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

1422: where
1423: last_update_date between l_date1 and l_date2;
1424:
1425: l_rows_inserted := sql%rowcount;
1426: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1427:
1428: if g_debug_flag = 'Y' then
1429: edw_log.put_line('Commiting records for EDW_PROJ_CATEG6_LSTG');
1430: end if;

Line 1498: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;

1494: where
1495: last_update_date between l_date1 and l_date2;
1496:
1497: l_rows_inserted := sql%rowcount;
1498: --FII_PROJECT_M_C.g_row_count := FII_PROJECT_M_C.g_row_count + l_rows_inserted ;
1499:
1500: if g_debug_flag = 'Y' then
1501: edw_log.put_line('Commiting records for EDW_PROJ_CATEG7_LSTG');
1502: end if;

Line 1518: End FII_PROJECT_M_C;

1514: commit;
1515:
1516: END;
1517:
1518: End FII_PROJECT_M_C;