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.IGS_UC_CONFIG_CYCLE dependencies on APPS_DDL

Line 92: apps_ddl.apps_ddl('CREATE SYNONYM ' || p_synonym || ' FOR ' || p_object || '@' || p_dblink_name);

88: -- Create synonym
89: IF p_mode = 'C' THEN
90:
91: -- Create synonymn to point to UCAS
92: apps_ddl.apps_ddl('CREATE SYNONYM ' || p_synonym || ' FOR ' || p_object || '@' || p_dblink_name);
93: log_msg(p_synonym, 'C');
94:
95: -- Try to access synonymn
96: BEGIN

Line 106: apps_ddl.apps_ddl('CREATE OR REPLACE SYNONYM ' || p_synonym || ' FOR ' || p_dummy);

102: EXCEPTION
103: WHEN OTHERS THEN
104: -- IF fail then log a message and create DUMMY synonym
105: log_msg(p_synonym , 'CF');
106: apps_ddl.apps_ddl('CREATE OR REPLACE SYNONYM ' || p_synonym || ' FOR ' || p_dummy);
107: log_msg(p_synonym, 'CD');
108:
109: -- set fail flag
110: g_synonym_fail := TRUE;

Line 116: apps_ddl.apps_ddl('CREATE SYNONYM ' || p_synonym || ' FOR ' || p_dummy);

112: END;
113:
114: -- Create Dummy Synonym
115: ELSE
116: apps_ddl.apps_ddl('CREATE SYNONYM ' || p_synonym || ' FOR ' || p_dummy);
117: log_msg(p_synonym, 'CD');
118:
119: END IF;
120:

Line 332: apps_ddl.apps_ddl('DROP SYNONYM ' || rec_cur_synonyms.object_name);

328: -- Drop all synonyms
329: FOR rec_cur_synonyms IN cur_synonyms LOOP
330: BEGIN
331:
332: apps_ddl.apps_ddl('DROP SYNONYM ' || rec_cur_synonyms.object_name);
333: log_msg(rec_cur_synonyms.object_name, 'D');
334:
335: EXCEPTION
336: WHEN OTHERS THEN

Line 945: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_CVCONTROL_2003_V COMPILE');

941: END IF;
942:
943: -- Compile all Data Source Views
944: BEGIN
945: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_CVCONTROL_2003_V COMPILE');
946: log_msg('IGS_UC_CVCONTROL_2003_V', 'O');
947: EXCEPTION
948: WHEN OTHERS THEN
949: retcode := 1 ;

Line 954: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVOFFER_2003_V COMPILE');

950: log_msg('IGS_UC_CVCONTROL_2003_V', 'I');
951: END;
952:
953: BEGIN
954: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVOFFER_2003_V COMPILE');
955: log_msg('IGS_UC_IVOFFER_2003_V', 'O');
956: EXCEPTION
957: WHEN OTHERS THEN
958: retcode := 1 ;

Line 963: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVQUALIFICATION_2003_V COMPILE');

959: log_msg('IGS_UC_IVOFFER_2003_V', 'I');
960: END;
961:
962: BEGIN
963: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVQUALIFICATION_2003_V COMPILE');
964: log_msg('IGS_UC_IVQUALIFICATION_2003_V', 'O');
965: EXCEPTION
966: WHEN OTHERS THEN
967: retcode := 1 ;

Line 972: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARA_2003_V COMPILE');

968: log_msg('IGS_UC_IVQUALIFICATION_2003_V', 'I');
969: END;
970:
971: BEGIN
972: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARA_2003_V COMPILE');
973: log_msg('IGS_UC_IVSTARA_2003_V', 'O');
974: EXCEPTION
975: WHEN OTHERS THEN
976: retcode := 1 ;

Line 981: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARC_2003_V COMPILE');

977: log_msg('IGS_UC_IVSTARA_2003_V', 'I');
978: END;
979:
980: BEGIN
981: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARC_2003_V COMPILE');
982: log_msg('IGS_UC_IVSTARC_2003_V', 'O');
983: EXCEPTION
984: WHEN OTHERS THEN
985: retcode := 1 ;

Line 990: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARH_2003_V COMPILE');

986: log_msg('IGS_UC_IVSTARC_2003_V', 'I');
987: END;
988:
989: BEGIN
990: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARH_2003_V COMPILE');
991: log_msg('IGS_UC_IVSTARH_2003_V', 'O');
992: EXCEPTION
993: WHEN OTHERS THEN
994: retcode := 1 ;

Line 999: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARJ_2004_V COMPILE');

995: log_msg('IGS_UC_IVSTARH_2003_V', 'I');
996: END;
997:
998: BEGIN
999: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARJ_2004_V COMPILE');
1000: log_msg('IGS_UC_IVSTARJ_2004_V', 'O');
1001: EXCEPTION
1002: WHEN OTHERS THEN
1003: retcode := 1 ;

Line 1008: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARK_2003_V COMPILE');

1004: log_msg('IGS_UC_IVSTARJ_2004_V', 'I');
1005: END;
1006:
1007: BEGIN
1008: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARK_2003_V COMPILE');
1009: log_msg('IGS_UC_IVSTARK_2003_V', 'O');
1010: EXCEPTION
1011: WHEN OTHERS THEN
1012: retcode := 1 ;

Line 1017: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARN_2003_V COMPILE');

1013: log_msg('IGS_UC_IVSTARK_2003_V', 'I');
1014: END;
1015:
1016: BEGIN
1017: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARN_2003_V COMPILE');
1018: log_msg('IGS_UC_IVSTARN_2003_V', 'O');
1019: EXCEPTION
1020: WHEN OTHERS THEN
1021: retcode := 1 ;

Line 1026: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARPQR_2003_V COMPILE');

1022: log_msg('IGS_UC_IVSTARN_2003_V', 'I');
1023: END;
1024:
1025: BEGIN
1026: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARPQR_2003_V COMPILE');
1027: log_msg('IGS_UC_IVSTARPQR_2003_V', 'O');
1028: EXCEPTION
1029: WHEN OTHERS THEN
1030: retcode := 1 ;

Line 1035: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARW_2003_V COMPILE');

1031: log_msg('IGS_UC_IVSTARPQR_2003_V', 'I');
1032: END;
1033:
1034: BEGIN
1035: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARW_2003_V COMPILE');
1036: log_msg('IGS_UC_IVSTARW_2003_V', 'O');
1037: EXCEPTION
1038: WHEN OTHERS THEN
1039: retcode := 1 ;

Line 1044: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARX_2003_V COMPILE');

1040: log_msg('IGS_UC_IVSTARW_2003_V', 'I');
1041: END;
1042:
1043: BEGIN
1044: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARX_2003_V COMPILE');
1045: log_msg('IGS_UC_IVSTARX_2003_V', 'O');
1046: EXCEPTION
1047: WHEN OTHERS THEN
1048: retcode := 1 ;

Line 1053: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARZ1_2003_V COMPILE');

1049: log_msg('IGS_UC_IVSTARX_2003_V', 'I');
1050: END;
1051:
1052: BEGIN
1053: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARZ1_2003_V COMPILE');
1054: log_msg('IGS_UC_IVSTARZ1_2003_V', 'O');
1055: EXCEPTION
1056: WHEN OTHERS THEN
1057: retcode := 1 ;

Line 1062: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARZ2_2003_V COMPILE');

1058: log_msg('IGS_UC_IVSTARZ1_2003_V', 'I');
1059: END;
1060:
1061: BEGIN
1062: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARZ2_2003_V COMPILE');
1063: log_msg('IGS_UC_IVSTARZ2_2003_V', 'O');
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: retcode := 1 ;

Line 1071: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTATEMENT_2003_V COMPILE');

1067: log_msg('IGS_UC_IVSTARZ2_2003_V', 'I');
1068: END;
1069:
1070: BEGIN
1071: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTATEMENT_2003_V COMPILE');
1072: log_msg('IGS_UC_IVSTATEMENT_2003_V', 'O');
1073: EXCEPTION
1074: WHEN OTHERS THEN
1075: retcode := 1 ;

Line 1081: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTATEMENT_2004_V COMPILE');

1077: END;
1078:
1079: -- smaddali added new view IGS_UC_IVSTATEMENT_2004_V for bug#3098810
1080: BEGIN
1081: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTATEMENT_2004_V COMPILE');
1082: log_msg('IGS_UC_IVSTATEMENT_2004_V', 'O');
1083: EXCEPTION
1084: WHEN OTHERS THEN
1085: retcode := 1 ;

Line 1091: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVFORMQUALS_2004_V COMPILE');

1087: END;
1088:
1089:
1090: BEGIN
1091: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVFORMQUALS_2004_V COMPILE');
1092: log_msg('IGS_UC_IVFORMQUALS_2004_V', 'O');
1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: retcode := 1 ;

Line 1100: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVREFERENCE_2004_V COMPILE');

1096: log_msg('IGS_UC_IVFORMQUALS_2004_V', 'I');
1097: END;
1098:
1099: BEGIN
1100: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVREFERENCE_2004_V COMPILE');
1101: log_msg('IGS_UC_IVREFERENCE_2004_V', 'O');
1102: EXCEPTION
1103: WHEN OTHERS THEN
1104: retcode := 1 ;

Line 1109: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVREFERENCE_2006_V COMPILE');

1105: log_msg('IGS_UC_IVREFERENCE_2004_V', 'I');
1106: END;
1107:
1108: BEGIN
1109: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVREFERENCE_2006_V COMPILE');
1110: log_msg('IGS_UC_IVREFERENCE_2006_V', 'O');
1111: EXCEPTION
1112: WHEN OTHERS THEN
1113: retcode := 1 ;

Line 1118: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARA_2006_V COMPILE');

1114: log_msg('IGS_UC_IVREFERENCE_2006_V', 'I');
1115: END;
1116:
1117: BEGIN
1118: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARA_2006_V COMPILE');
1119: log_msg('IGS_UC_IVSTARA_2006_V', 'O');
1120: EXCEPTION
1121: WHEN OTHERS THEN
1122: retcode := 1 ;

Line 1127: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVFORMQUALS_2006_V COMPILE');

1123: log_msg('IGS_UC_IVSTARA_2006_V', 'I');
1124: END;
1125:
1126: BEGIN
1127: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVFORMQUALS_2006_V COMPILE');
1128: log_msg('IGS_UC_IVFORMQUALS_2006_V', 'O');
1129: EXCEPTION
1130: WHEN OTHERS THEN
1131: retcode := 1 ;

Line 1136: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARA_2007_V COMPILE');

1132: log_msg('IGS_UC_IVFORMQUALS_2006_V', 'I');
1133: END;
1134:
1135: BEGIN
1136: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARA_2007_V COMPILE');
1137: log_msg('IGS_UC_IVSTARA_2007_V', 'O');
1138: EXCEPTION
1139: WHEN OTHERS THEN
1140: retcode := 1 ;

Line 1145: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARN_2007_V COMPILE');

1141: log_msg('IGS_UC_IVSTARA_2007_V', 'I');
1142: END;
1143:
1144: BEGIN
1145: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARN_2007_V COMPILE');
1146: log_msg('IGS_UC_IVSTARN_2007_V', 'O');
1147: EXCEPTION
1148: WHEN OTHERS THEN
1149: retcode := 1 ;

Line 1154: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARK_2007_V COMPILE');

1150: log_msg('IGS_UC_IVSTARN_2007_V', 'I');
1151: END;
1152:
1153: BEGIN
1154: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVSTARK_2007_V COMPILE');
1155: log_msg('IGS_UC_IVSTARK_2007_V', 'O');
1156: EXCEPTION
1157: WHEN OTHERS THEN
1158: retcode := 1 ;

Line 1164: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGOFFER_2006_V COMPILE');

1160: END;
1161:
1162: -- Small System 2006 Views
1163: BEGIN
1164: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGOFFER_2006_V COMPILE');
1165: log_msg('IGS_UC_IVGOFFER_2006_V', 'O');
1166: EXCEPTION
1167: WHEN OTHERS THEN
1168: retcode := 1 ;

Line 1173: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNOFFER_2006_V COMPILE');

1169: log_msg('IGS_UC_IVGOFFER_2006_V', 'I');
1170: END;
1171:
1172: BEGIN
1173: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNOFFER_2006_V COMPILE');
1174: log_msg('IGS_UC_IVNOFFER_2006_V', 'O');
1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: retcode := 1 ;

Line 1182: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARA_2006_V COMPILE');

1178: log_msg('IGS_UC_IVNOFFER_2006_V', 'I');
1179: END;
1180:
1181: BEGIN
1182: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARA_2006_V COMPILE');
1183: log_msg('IGS_UC_IVGSTARA_2006_V', 'O');
1184: EXCEPTION
1185: WHEN OTHERS THEN
1186: retcode := 1 ;

Line 1191: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARA_2006_V COMPILE');

1187: log_msg('IGS_UC_IVGSTARA_2006_V', 'I');
1188: END;
1189:
1190: BEGIN
1191: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARA_2006_V COMPILE');
1192: log_msg('IGS_UC_IVNSTARA_2006_V', 'O');
1193: EXCEPTION
1194: WHEN OTHERS THEN
1195: retcode := 1 ;

Line 1200: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARC_2006_V COMPILE');

1196: log_msg('IGS_UC_IVNSTARA_2006_V', 'I');
1197: END;
1198:
1199: BEGIN
1200: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARC_2006_V COMPILE');
1201: log_msg('IGS_UC_IVNSTARC_2006_V', 'O');
1202: EXCEPTION
1203: WHEN OTHERS THEN
1204: retcode := 1 ;

Line 1209: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARG_2006_V COMPILE');

1205: log_msg('IGS_UC_IVNSTARC_2006_V', 'I');
1206: END;
1207:
1208: BEGIN
1209: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARG_2006_V COMPILE');
1210: log_msg('IGS_UC_IVGSTARG_2006_V', 'O');
1211: EXCEPTION
1212: WHEN OTHERS THEN
1213: retcode := 1 ;

Line 1218: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARH_2006_V COMPILE');

1214: log_msg('IGS_UC_IVGSTARG_2006_V', 'I');
1215: END;
1216:
1217: BEGIN
1218: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARH_2006_V COMPILE');
1219: log_msg('IGS_UC_IVGSTARH_2006_V', 'O');
1220: EXCEPTION
1221: WHEN OTHERS THEN
1222: retcode := 1 ;

Line 1227: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARH_2006_V COMPILE');

1223: log_msg('IGS_UC_IVGSTARH_2006_V', 'I');
1224: END;
1225:
1226: BEGIN
1227: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARH_2006_V COMPILE');
1228: log_msg('IGS_UC_IVNSTARH_2006_V', 'O');
1229: EXCEPTION
1230: WHEN OTHERS THEN
1231: retcode := 1 ;

Line 1236: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARK_2006_V COMPILE');

1232: log_msg('IGS_UC_IVNSTARH_2006_V', 'I');
1233: END;
1234:
1235: BEGIN
1236: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARK_2006_V COMPILE');
1237: log_msg('IGS_UC_IVGSTARK_2006_V', 'O');
1238: EXCEPTION
1239: WHEN OTHERS THEN
1240: retcode := 1 ;

Line 1245: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARK_2006_V COMPILE');

1241: log_msg('IGS_UC_IVGSTARK_2006_V', 'I');
1242: END;
1243:
1244: BEGIN
1245: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARK_2006_V COMPILE');
1246: log_msg('IGS_UC_IVNSTARK_2006_V', 'O');
1247: EXCEPTION
1248: WHEN OTHERS THEN
1249: retcode := 1 ;

Line 1254: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARN_2006_V COMPILE');

1250: log_msg('IGS_UC_IVNSTARK_2006_V', 'I');
1251: END;
1252:
1253: BEGIN
1254: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARN_2006_V COMPILE');
1255: log_msg('IGS_UC_IVGSTARN_2006_V', 'O');
1256: EXCEPTION
1257: WHEN OTHERS THEN
1258: retcode := 1 ;

Line 1263: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARN_2006_V COMPILE');

1259: log_msg('IGS_UC_IVGSTARN_2006_V', 'I');
1260: END;
1261:
1262: BEGIN
1263: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARN_2006_V COMPILE');
1264: log_msg('IGS_UC_IVNSTARN_2006_V', 'O');
1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: retcode := 1 ;

Line 1272: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARW_2006_V COMPILE');

1268: log_msg('IGS_UC_IVNSTARN_2006_V', 'I');
1269: END;
1270:
1271: BEGIN
1272: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARW_2006_V COMPILE');
1273: log_msg('IGS_UC_IVGSTARW_2006_V', 'O');
1274: EXCEPTION
1275: WHEN OTHERS THEN
1276: retcode := 1 ;

Line 1281: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARW_2006_V COMPILE');

1277: log_msg('IGS_UC_IVGSTARW_2006_V', 'I');
1278: END;
1279:
1280: BEGIN
1281: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARW_2006_V COMPILE');
1282: log_msg('IGS_UC_IVNSTARW_2006_V', 'O');
1283: EXCEPTION
1284: WHEN OTHERS THEN
1285: retcode := 1 ;

Line 1290: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARX_2006_V COMPILE');

1286: log_msg('IGS_UC_IVNSTARW_2006_V', 'I');
1287: END;
1288:
1289: BEGIN
1290: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARX_2006_V COMPILE');
1291: log_msg('IGS_UC_IVGSTARX_2006_V', 'O');
1292: EXCEPTION
1293: WHEN OTHERS THEN
1294: retcode := 1 ;

Line 1299: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARX_2006_V COMPILE');

1295: log_msg('IGS_UC_IVGSTARX_2006_V', 'I');
1296: END;
1297:
1298: BEGIN
1299: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARX_2006_V COMPILE');
1300: log_msg('IGS_UC_IVNSTARX_2006_V', 'O');
1301: EXCEPTION
1302: WHEN OTHERS THEN
1303: retcode := 1 ;

Line 1308: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARZ1_2006_V COMPILE');

1304: log_msg('IGS_UC_IVNSTARX_2006_V', 'I');
1305: END;
1306:
1307: BEGIN
1308: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARZ1_2006_V COMPILE');
1309: log_msg('IGS_UC_IVNSTARZ1_2006_V', 'O');
1310: EXCEPTION
1311: WHEN OTHERS THEN
1312: retcode := 1 ;

Line 1317: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTATEMENT_2006_V COMPILE');

1313: log_msg('IGS_UC_IVNSTARZ1_2006_V', 'I');
1314: END;
1315:
1316: BEGIN
1317: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTATEMENT_2006_V COMPILE');
1318: log_msg('IGS_UC_IVGSTATEMENT_2006_V', 'O');
1319: EXCEPTION
1320: WHEN OTHERS THEN
1321: retcode := 1 ;

Line 1326: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTATEMENT_2006_V COMPILE');

1322: log_msg('IGS_UC_IVGSTATEMENT_2006_V', 'I');
1323: END;
1324:
1325: BEGIN
1326: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTATEMENT_2006_V COMPILE');
1327: log_msg('IGS_UC_IVNSTATEMENT_2006_V', 'O');
1328: EXCEPTION
1329: WHEN OTHERS THEN
1330: retcode := 1 ;

Line 1335: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGREFERENCE_2006_V COMPILE');

1331: log_msg('IGS_UC_IVNSTATEMENT_2006_V', 'I');
1332: END;
1333:
1334: BEGIN
1335: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGREFERENCE_2006_V COMPILE');
1336: log_msg('IGS_UC_IVGREFERENCE_2006_V', 'O');
1337: EXCEPTION
1338: WHEN OTHERS THEN
1339: retcode := 1 ;

Line 1344: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNREFERENCE_2006_V COMPILE');

1340: log_msg('IGS_UC_IVGREFERENCE_2006_V', 'I');
1341: END;
1342:
1343: BEGIN
1344: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNREFERENCE_2006_V COMPILE');
1345: log_msg('IGS_UC_IVNREFERENCE_2006_V', 'O');
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: retcode := 1 ;

Line 1354: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARA_2007_V COMPILE');

1350: END;
1351:
1352: -- Small System 2007 views
1353: BEGIN
1354: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARA_2007_V COMPILE');
1355: log_msg('IGS_UC_IVGSTARA_2007_V', 'O');
1356: EXCEPTION
1357: WHEN OTHERS THEN
1358: retcode := 1 ;

Line 1363: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARA_2007_V COMPILE');

1359: log_msg('IGS_UC_IVGSTARA_2007_V', 'I');
1360: END;
1361:
1362: BEGIN
1363: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARA_2007_V COMPILE');
1364: log_msg('IGS_UC_IVNSTARA_2007_V', 'O');
1365: EXCEPTION
1366: WHEN OTHERS THEN
1367: retcode := 1 ;

Line 1372: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARN_2007_V COMPILE');

1368: log_msg('IGS_UC_IVNSTARA_2007_V', 'I');
1369: END;
1370:
1371: BEGIN
1372: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARN_2007_V COMPILE');
1373: log_msg('IGS_UC_IVGSTARN_2007_V', 'O');
1374: EXCEPTION
1375: WHEN OTHERS THEN
1376: retcode := 1 ;

Line 1381: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARN_2007_V COMPILE');

1377: log_msg('IGS_UC_IVGSTARN_2007_V', 'I');
1378: END;
1379:
1380: BEGIN
1381: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARN_2007_V COMPILE');
1382: log_msg('IGS_UC_IVNSTARN_2007_V', 'O');
1383: EXCEPTION
1384: WHEN OTHERS THEN
1385: retcode := 1 ;

Line 1390: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARK_2007_V COMPILE');

1386: log_msg('IGS_UC_IVNSTARN_2007_V', 'I');
1387: END;
1388:
1389: BEGIN
1390: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARK_2007_V COMPILE');
1391: log_msg('IGS_UC_IVGSTARK_2007_V', 'O');
1392: EXCEPTION
1393: WHEN OTHERS THEN
1394: retcode := 1 ;

Line 1399: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARK_2007_V COMPILE');

1395: log_msg('IGS_UC_IVGSTARK_2007_V', 'I');
1396: END;
1397:
1398: BEGIN
1399: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARK_2007_V COMPILE');
1400: log_msg('IGS_UC_IVNSTARK_2007_V', 'O');
1401: EXCEPTION
1402: WHEN OTHERS THEN
1403: retcode := 1 ;

Line 1409: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARW_2007_V COMPILE');

1405: END;
1406:
1407:
1408: BEGIN
1409: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVGSTARW_2007_V COMPILE');
1410: log_msg('IGS_UC_IVGSTARW_2007_V', 'O');
1411: EXCEPTION
1412: WHEN OTHERS THEN
1413: retcode := 1 ;

Line 1418: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARW_2007_V COMPILE');

1414: log_msg('IGS_UC_IVGSTARW_2007_V', 'I');
1415: END;
1416:
1417: BEGIN
1418: apps_ddl.apps_ddl('ALTER VIEW IGS_UC_IVNSTARW_2007_V COMPILE');
1419: log_msg('IGS_UC_IVNSTARW_2007_V', 'O');
1420: EXCEPTION
1421: WHEN OTHERS THEN
1422: retcode := 1 ;

Line 1428: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_LOAD_HERCULES_DATA COMPILE BODY');

1424: END;
1425:
1426: -- Compile all database packages (body)
1427: BEGIN
1428: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_LOAD_HERCULES_DATA COMPILE BODY');
1429: -- Log message for compiling packages
1430: log_msg('IGS_UC_LOAD_HERCULES_DATA', 'O');
1431: EXCEPTION
1432: WHEN OTHERS THEN

Line 1438: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_EXT_MARVIN COMPILE BODY');

1434: log_msg('IGS_UC_LOAD_HERCULES_DATA', 'I');
1435: END;
1436:
1437: BEGIN
1438: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_EXT_MARVIN COMPILE BODY');
1439: -- Log message for compiling packages
1440: log_msg('IGS_UC_EXT_MARVIN', 'O');
1441: EXCEPTION
1442: WHEN OTHERS THEN

Line 1448: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_MV_DATA_UPLD COMPILE BODY');

1444: log_msg('IGS_UC_EXT_MARVIN', 'I');
1445: END;
1446:
1447: BEGIN
1448: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_MV_DATA_UPLD COMPILE BODY');
1449: -- Log message for compiling packages
1450: log_msg('IGS_UC_MV_DATA_UPLD', 'O');
1451: EXCEPTION
1452: WHEN OTHERS THEN

Line 1458: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_EXPORT_UCAS_PKG COMPILE BODY');

1454: log_msg('IGS_UC_MV_DATA_UPLD', 'I');
1455: END;
1456:
1457: BEGIN
1458: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_EXPORT_UCAS_PKG COMPILE BODY');
1459: -- Log message for compiling packages
1460: log_msg('IGS_UC_EXPORT_UCAS_PKG', 'O');
1461: EXCEPTION
1462: WHEN OTHERS THEN

Line 1468: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_TRAN_PROCESSOR_PKG COMPILE BODY');

1464: log_msg('IGS_UC_EXPORT_UCAS_PKG', 'I');
1465: END;
1466:
1467: BEGIN
1468: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_TRAN_PROCESSOR_PKG COMPILE BODY');
1469: -- Log message for compiling packages
1470: log_msg('IGS_UC_TRAN_PROCESSOR_PKG', 'O');
1471: EXCEPTION
1472: WHEN OTHERS THEN

Line 1479: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_GEN_001 COMPILE BODY');

1475: END;
1476:
1477: -- Compile the gen 001 package
1478: BEGIN
1479: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_GEN_001 COMPILE BODY');
1480: log_msg('IGS_UC_GEN_001', 'O');
1481: EXCEPTION
1482: WHEN OTHERS THEN
1483: retcode := 1 ;

Line 1489: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_PROC_COM_INST_DATA COMPILE BODY');

1485: END;
1486:
1487: --Bug No: 3083664. Package IGS_UC_PROC_COM_INST_DATA included for compilation
1488: BEGIN
1489: apps_ddl.apps_ddl('ALTER PACKAGE IGS_UC_PROC_COM_INST_DATA COMPILE BODY');
1490: log_msg('IGS_UC_PROC_COM_INST_DATA', 'O');
1491: EXCEPTION
1492: WHEN OTHERS THEN
1493: retcode := 1 ;