APPS.FII_PROJECT_M_C dependencies on EDW_PROJ_CATEG2_LSTG

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 1088: Procedure Push_EDW_PROJ_CATEG2_LSTG(p_from_date IN date, p_to_date IN DATE) IS

1084:
1085: END;
1086:
1087:
1088: Procedure Push_EDW_PROJ_CATEG2_LSTG(p_from_date IN date, p_to_date IN DATE) IS
1089:
1090: l_date1 DATE;
1091: l_date2 DATE;
1092: l_rows_inserted NUMBER :=0;

Line 1097: edw_log.put_line('Starting Push_EDW_PROJ_CATEG2_LSTG');

1093:
1094: BEGIN
1095:
1096: if g_debug_flag = 'Y' then
1097: edw_log.put_line('Starting Push_EDW_PROJ_CATEG2_LSTG');
1098: end if;
1099:
1100: l_date1 := p_from_date;
1101: l_date2 := p_to_date;

Line 1103: Insert Into EDW_PROJ_CATEG2_LSTG

1099:
1100: l_date1 := p_from_date;
1101: l_date2 := p_to_date;
1102:
1103: Insert Into EDW_PROJ_CATEG2_LSTG
1104: (
1105: ALL_FK,
1106: DELETION_DATE,
1107: INSTANCE,

Line 1142: edw_log.put_line('Commiting records for EDW_PROJ_CATEG2_LSTG');

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;
1144:
1145: commit;
1146:

Line 1148: edw_log.put_line('Completed Push_EDW_PROJ_CATEG2_LSTG');

1144:
1145: commit;
1146:
1147: if g_debug_flag = 'Y' then
1148: edw_log.put_line('Completed Push_EDW_PROJ_CATEG2_LSTG');
1149: end if;
1150:
1151: Exception
1152: