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.ISC_EDW_BOOKINGS_F_C dependencies on FII_UTIL

Line 1055: FII_UTIL.Start_Timer;

1051: -- ---------------------------------------
1052:
1053: EDW_LOG.Put_Line('Identifying changed Booked orders lines');
1054:
1055: FII_UTIL.Start_Timer;
1056:
1057: g_seq_id_line_1 := Identify_Change(1,-1 , l_row_count);
1058:
1059: FII_UTIL.Stop_Timer;

Line 1059: FII_UTIL.Stop_Timer;

1055: FII_UTIL.Start_Timer;
1056:
1057: g_seq_id_line_1 := Identify_Change(1,-1 , l_row_count);
1058:
1059: FII_UTIL.Stop_Timer;
1060: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in ');
1061:
1062: IF (g_seq_id_line_1 = -1)
1063: THEN RAISE l_failure;

Line 1060: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in ');

1056:
1057: g_seq_id_line_1 := Identify_Change(1,-1 , l_row_count);
1058:
1059: FII_UTIL.Stop_Timer;
1060: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in ');
1061:
1062: IF (g_seq_id_line_1 = -1)
1063: THEN RAISE l_failure;
1064: END IF;

Line 1074: FII_UTIL.Start_Timer;

1070:
1071: EDW_LOG.Put_Line(' ');
1072: EDW_LOG.Put_Line('Identifying changed for reserved orders');
1073:
1074: FII_UTIL.Start_Timer;
1075:
1076: g_seq_id_line_2 := Identify_Change(2, g_seq_id_line_1, l_row_count);
1077:
1078: FII_UTIL.Stop_Timer;

Line 1078: FII_UTIL.Stop_Timer;

1074: FII_UTIL.Start_Timer;
1075:
1076: g_seq_id_line_2 := Identify_Change(2, g_seq_id_line_1, l_row_count);
1077:
1078: FII_UTIL.Stop_Timer;
1079: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in ');
1080:
1081: IF (g_seq_id_line_2 = -1)
1082: THEN RAISE l_failure;

Line 1079: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in ');

1075:
1076: g_seq_id_line_2 := Identify_Change(2, g_seq_id_line_1, l_row_count);
1077:
1078: FII_UTIL.Stop_Timer;
1079: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in ');
1080:
1081: IF (g_seq_id_line_2 = -1)
1082: THEN RAISE l_failure;
1083: END IF;

Line 1093: FII_UTIL.Start_Timer;

1089:
1090: EDW_LOG.Put_Line(' ');
1091: EDW_LOG.Put_Line('Identifying changed for Multi-Cancellations orders');
1092:
1093: FII_UTIL.Start_Timer;
1094:
1095: g_seq_id_line_3 := Identify_Change(3, g_seq_id_line_1, l_row_count);
1096:
1097: FII_UTIL.Stop_Timer;

Line 1097: FII_UTIL.Stop_Timer;

1093: FII_UTIL.Start_Timer;
1094:
1095: g_seq_id_line_3 := Identify_Change(3, g_seq_id_line_1, l_row_count);
1096:
1097: FII_UTIL.Stop_Timer;
1098: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in ');
1099:
1100: IF (g_seq_id_line_3 = -1)
1101: THEN RAISE l_failure;

Line 1098: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in ');

1094:
1095: g_seq_id_line_3 := Identify_Change(3, g_seq_id_line_1, l_row_count);
1096:
1097: FII_UTIL.Stop_Timer;
1098: FII_UTIL.Print_Timer('Identified '||l_row_count||' changed records in ');
1099:
1100: IF (g_seq_id_line_3 = -1)
1101: THEN RAISE l_failure;
1102: END IF;

Line 1112: FII_UTIL.Start_Timer;

1108:
1109: EDW_LOG.Put_Line(' ');
1110: EDW_LOG.Put_Line('Identifying the missing conversion rates (currency and UoM)');
1111:
1112: FII_UTIL.Start_Timer;
1113:
1114: g_miss_conv := Identify_Missing_Rate (l_row_count);
1115:
1116: FII_UTIL.Stop_Timer;

Line 1116: FII_UTIL.Stop_Timer;

1112: FII_UTIL.Start_Timer;
1113:
1114: g_miss_conv := Identify_Missing_Rate (l_row_count);
1115:
1116: FII_UTIL.Stop_Timer;
1117:
1118: IF (g_miss_conv = -1)
1119: THEN RAISE l_failure;
1120: END IF;

Line 1122: FII_UTIL.Print_Timer('Inserted '||g_miss_conv||' rows into the ISC_EDW_BOOK_MISSING_RATE table in ');

1118: IF (g_miss_conv = -1)
1119: THEN RAISE l_failure;
1120: END IF;
1121:
1122: FII_UTIL.Print_Timer('Inserted '||g_miss_conv||' rows into the ISC_EDW_BOOK_MISSING_RATE table in ');
1123: EDW_LOG.Put_Line(' ');
1124:
1125:
1126: -- --------------------------------------------------------------------

Line 1133: FII_UTIL.Start_Timer;

1129:
1130: EDW_LOG.Put_Line(' ');
1131: EDW_LOG.Put_Line('Inserting into ISC_TMP_PK with < 0 seq_id the rows having missing conversion rates (currency and UoM)');
1132:
1133: FII_UTIL.Start_Timer;
1134:
1135: g_row_count := Insert_Isc_Tmp_Pk (l_row_count);
1136:
1137: FII_UTIL.Stop_Timer;

Line 1137: FII_UTIL.Stop_Timer;

1133: FII_UTIL.Start_Timer;
1134:
1135: g_row_count := Insert_Isc_Tmp_Pk (l_row_count);
1136:
1137: FII_UTIL.Stop_Timer;
1138:
1139: IF (g_row_count = -1)
1140: THEN RAISE l_failure;
1141: END IF;

Line 1143: FII_UTIL.Print_Timer('Inserted '||l_row_count||' rows into the ISC_TMP_PK table in ');

1139: IF (g_row_count = -1)
1140: THEN RAISE l_failure;
1141: END IF;
1142:
1143: FII_UTIL.Print_Timer('Inserted '||l_row_count||' rows into the ISC_TMP_PK table in ');
1144: EDW_LOG.Put_Line(' ');
1145:
1146:
1147: -- --------------------------------------------

Line 1154: FII_UTIL.Start_Timer;

1150:
1151: EDW_LOG.Put_Line(' ');
1152: EDW_LOG.Put_Line('Deleting the ISC_TMP_PK rows having a missing conversion rates before collecting (currency and UoM)');
1153:
1154: FII_UTIL.Start_Timer;
1155:
1156: g_row_count := Delete_Isc_Tmp_Pk ;
1157:
1158: FII_UTIL.Stop_Timer;

Line 1158: FII_UTIL.Stop_Timer;

1154: FII_UTIL.Start_Timer;
1155:
1156: g_row_count := Delete_Isc_Tmp_Pk ;
1157:
1158: FII_UTIL.Stop_Timer;
1159:
1160: IF (g_row_count = -1)
1161: THEN RAISE l_failure;
1162: END IF;

Line 1164: FII_UTIL.Print_Timer('Deleted '||g_row_count||' rows from the ISC_TMP_PK table in ');

1160: IF (g_row_count = -1)
1161: THEN RAISE l_failure;
1162: END IF;
1163:
1164: FII_UTIL.Print_Timer('Deleted '||g_row_count||' rows from the ISC_TMP_PK table in ');
1165: EDW_LOG.Put_Line(' ');
1166:
1167:
1168: IF NOT ((g_all_or_nothing_flag = 'Y') and (g_miss_conv > 0)) -- collect except when this condition applies

Line 1183: FII_UTIL.Start_Timer;

1179: EDW_LOG.Put_Line( 'The collection range is from '||
1180: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1181: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
1182:
1183: FII_UTIL.Start_Timer;
1184:
1185: g_row_count := Push_To_Local(1,g_seq_id_line_1);
1186:
1187: FII_UTIL.Stop_Timer;

Line 1187: FII_UTIL.Stop_Timer;

1183: FII_UTIL.Start_Timer;
1184:
1185: g_row_count := Push_To_Local(1,g_seq_id_line_1);
1186:
1187: FII_UTIL.Stop_Timer;
1188:
1189: IF (g_row_count = -1)
1190: THEN RAISE l_failure;
1191: END IF;

Line 1195: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows with view type = 1 into the local staging table in ');

1191: END IF;
1192:
1193: g_rows_collected := g_row_count;
1194:
1195: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows with view type = 1 into the local staging table in ');
1196: EDW_LOG.Put_Line(' ');
1197:
1198:
1199: -- -------------------------------------------

Line 1212: FII_UTIL.Start_Timer;

1208: to_char(g_push_from_date,'MM/DD/YYYY HH24:MI:SS')||' to '||
1209: to_char(g_push_to_date,'MM/DD/YYYY HH24:MI:SS'));
1210: EDW_LOG.Put_Line(' ');
1211:
1212: FII_UTIL.Start_Timer;
1213:
1214: g_row_count := Push_To_Local(2,g_seq_id_line_2);
1215:
1216: FII_UTIL.Stop_Timer;

Line 1216: FII_UTIL.Stop_Timer;

1212: FII_UTIL.Start_Timer;
1213:
1214: g_row_count := Push_To_Local(2,g_seq_id_line_2);
1215:
1216: FII_UTIL.Stop_Timer;
1217:
1218: IF (g_row_count = -1)
1219: THEN RAISE l_failure;
1220: END IF;

Line 1224: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows with view type = 2 into the local staging table in ');

1220: END IF;
1221:
1222: g_rows_collected := g_rows_collected + g_row_count;
1223:
1224: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows with view type = 2 into the local staging table in ');
1225: EDW_LOG.Put_Line(' ');
1226:
1227:
1228: -- -------------------------------------------

Line 1236: FII_UTIL.Start_Timer;

1232: EDW_LOG.Put_Line(' ');
1233: EDW_LOG.Put_Line('Pushing data to local staging with the view type = 3');
1234: EDW_LOG.Put_Line(' ');
1235:
1236: FII_UTIL.Start_Timer;
1237:
1238: g_row_count := Push_To_Local(3,g_seq_id_line_3);
1239:
1240: FII_UTIL.Stop_Timer;

Line 1240: FII_UTIL.Stop_Timer;

1236: FII_UTIL.Start_Timer;
1237:
1238: g_row_count := Push_To_Local(3,g_seq_id_line_3);
1239:
1240: FII_UTIL.Stop_Timer;
1241:
1242: IF (g_row_count = -1)
1243: THEN RAISE l_failure;
1244: END IF;

Line 1248: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows with view type = 3 into the local staging table in ');

1244: END IF;
1245:
1246: g_rows_collected := g_rows_collected + g_row_count;
1247:
1248: FII_UTIL.Print_Timer('Inserted '||g_row_count||' rows with view type = 3 into the local staging table in ');
1249: EDW_LOG.Put_Line(' ');
1250:
1251: EDW_LOG.Put_Line(' ');
1252: EDW_LOG.Put_Line('Marking rows to be deleted from the Fact (rows having beeing deleted from the source instance table)');

Line 1255: FII_UTIL.Start_Timer;

1251: EDW_LOG.Put_Line(' ');
1252: EDW_LOG.Put_Line('Marking rows to be deleted from the Fact (rows having beeing deleted from the source instance table)');
1253: EDW_LOG.Put_Line(' ');
1254:
1255: FII_UTIL.Start_Timer;
1256:
1257: g_row_count := Deletion_Handling;
1258:
1259: FII_UTIL.Stop_Timer;

Line 1259: FII_UTIL.Stop_Timer;

1255: FII_UTIL.Start_Timer;
1256:
1257: g_row_count := Deletion_Handling;
1258:
1259: FII_UTIL.Stop_Timer;
1260:
1261: IF (g_row_count = -1)
1262: THEN RAISE l_failure;
1263: END IF;

Line 1265: FII_UTIL.Print_Timer('Marked '||g_row_count||' rows to be deleted from the Fact in ');

1261: IF (g_row_count = -1)
1262: THEN RAISE l_failure;
1263: END IF;
1264:
1265: FII_UTIL.Print_Timer('Marked '||g_row_count||' rows to be deleted from the Fact in ');
1266: EDW_LOG.Put_Line(' ');
1267:
1268: END;
1269: END IF; -- IF NOT ((g_all_or_nothing_flag = 'Y') and (g_miss_conv > 0))