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.OTA_TAV_BUS dependencies on OTA_ACTIVITY_VERSIONS

Line 99: ,p_descflex_name => 'OTA_ACTIVITY_VERSIONS'

95: -- b) During insert.
96: --
97: hr_dflex_utility.ins_or_upd_descflex_attribs
98: (p_appl_short_name => 'OTA'
99: ,p_descflex_name => 'OTA_ACTIVITY_VERSIONS'
100: ,p_attribute_category => p_rec.tav_information_category
101: ,p_attribute1_name => 'TAV_INFORMATION1'
102: ,p_attribute1_value => p_rec.tav_information1
103: ,p_attribute2_name => 'TAV_INFORMATION2'

Line 177: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.MINIMUM_ATTENDEES'

173: --
174: exception
175: when app_exception.application_exception then
176: if hr_multi_message.exception_add
177: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.MINIMUM_ATTENDEES'
178: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.MAXIMUM_ATTENDEES'
179: ) then
180: hr_utility.set_location(' Leaving:'|| v_proc,70);
181: raise;

Line 178: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.MAXIMUM_ATTENDEES'

174: exception
175: when app_exception.application_exception then
176: if hr_multi_message.exception_add
177: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.MINIMUM_ATTENDEES'
178: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.MAXIMUM_ATTENDEES'
179: ) then
180: hr_utility.set_location(' Leaving:'|| v_proc,70);
181: raise;
182: end if;

Line 272: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.COMPETENCY_UPDATE_LEVEL') THEN

268:
269: WHEN app_exception.application_exception THEN
270:
271: IF hr_multi_message.exception_add
272: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.COMPETENCY_UPDATE_LEVEL') THEN
273:
274: hr_utility.set_location(' Leaving:'||l_proc, 42);
275: RAISE;
276: END IF;

Line 313: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.SUPERSEDE_BY_ACT_VERSION_ID'

309: --
310: exception
311: when app_exception.application_exception then
312: if hr_multi_message.exception_add
313: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.SUPERSEDE_BY_ACT_VERSION_ID'
314: ) then
315: hr_utility.set_location(' Leaving:'|| v_proc,70);
316: raise;
317: end if;

Line 347: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.USER_STATUS'

343: --
344: exception
345: when app_exception.application_exception then
346: if hr_multi_message.exception_add
347: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.USER_STATUS'
348: ) then
349: hr_utility.set_location(' Leaving:'|| v_proc,70);
350: raise;
351: end if;

Line 381: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.SUCCESS_CRITERIA'

377: --
378: exception
379: when app_exception.application_exception then
380: if hr_multi_message.exception_add
381: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.SUCCESS_CRITERIA'
382: ) then
383: hr_utility.set_location(' Leaving:'|| v_proc,70);
384: raise;
385: end if;

Line 468: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

464: --
465: exception
466: when app_exception.application_exception then
467: if hr_multi_message.exception_add
468: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
469: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
470: ) then
471: hr_utility.set_location(' Leaving:'|| v_proc,70);
472: raise;

Line 469: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

465: exception
466: when app_exception.application_exception then
467: if hr_multi_message.exception_add
468: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
469: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
470: ) then
471: hr_utility.set_location(' Leaving:'|| v_proc,70);
472: raise;
473: end if;

Line 522: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

518: end if;
519: exception
520: when app_exception.application_exception then
521: if hr_multi_message.exception_add
522: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
523: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
524: ) then
525: hr_utility.set_location(' Leaving:'|| v_proc,70);
526: raise;

Line 523: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

519: exception
520: when app_exception.application_exception then
521: if hr_multi_message.exception_add
522: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
523: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
524: ) then
525: hr_utility.set_location(' Leaving:'|| v_proc,70);
526: raise;
527: end if;

Line 567: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

563: end if;
564: exception
565: when app_exception.application_exception then
566: if hr_multi_message.exception_add
567: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
568: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
569: ) then
570: hr_utility.set_location(' Leaving:'|| v_proc,70);
571: raise;

Line 568: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

564: exception
565: when app_exception.application_exception then
566: if hr_multi_message.exception_add
567: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
568: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
569: ) then
570: hr_utility.set_location(' Leaving:'|| v_proc,70);
571: raise;
572: end if;

Line 615: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

611: end if;
612: exception
613: when app_exception.application_exception then
614: if hr_multi_message.exception_add
615: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
616: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
617: ) then
618: hr_utility.set_location(' Leaving:'|| v_proc,70);
619: raise;

Line 616: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

612: exception
613: when app_exception.application_exception then
614: if hr_multi_message.exception_add
615: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
616: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
617: ) then
618: hr_utility.set_location(' Leaving:'|| v_proc,70);
619: raise;
620: end if;

Line 661: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

657: end if;
658: exception
659: when app_exception.application_exception then
660: if hr_multi_message.exception_add
661: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
662: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
663: ) then
664: hr_utility.set_location(' Leaving:'|| v_proc,70);
665: raise;

Line 662: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

658: exception
659: when app_exception.application_exception then
660: if hr_multi_message.exception_add
661: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
662: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
663: ) then
664: hr_utility.set_location(' Leaving:'|| v_proc,70);
665: raise;
666: end if;

Line 699: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'

695: --
696: exception
697: when app_exception.application_exception then
698: if hr_multi_message.exception_add
699: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
700: ) then
701: hr_utility.set_location(' Leaving:'|| v_proc,70);
702: raise;
703: end if;

Line 734: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'

730: --
731: exception
732: when app_exception.application_exception then
733: if hr_multi_message.exception_add
734: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
735: ) then
736: hr_utility.set_location(' Leaving:'|| v_proc,70);
737: raise;
738: end if;

Line 771: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'

767: --
768: exception
769: when app_exception.application_exception then
770: if hr_multi_message.exception_add
771: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
772: ) then
773: hr_utility.set_location(' Leaving:'|| v_proc,70);
774: raise;
775: end if;

Line 809: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'

805: --
806: exception
807: when app_exception.application_exception then
808: if hr_multi_message.exception_add
809: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
810: ) then
811: hr_utility.set_location(' Leaving:'|| v_proc,70);
812: raise;
813: end if;

Line 847: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'

843: --
844: exception
845: when app_exception.application_exception then
846: if hr_multi_message.exception_add
847: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
848: ) then
849: hr_utility.set_location(' Leaving:'|| v_proc,70);
850: raise;
851: end if;

Line 884: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'

880: --
881: exception
882: when app_exception.application_exception then
883: if hr_multi_message.exception_add
884: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
885: ) then
886: hr_utility.set_location(' Leaving:'|| v_proc,70);
887: raise;
888: end if;

Line 921: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'

917: --
918: exception
919: when app_exception.application_exception then
920: if hr_multi_message.exception_add
921: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
922: ) then
923: hr_utility.set_location(' Leaving:'|| v_proc,70);
924: raise;
925: end if;

Line 937: -- ota_activity_versions exists where this activity version has superseded

933: -- PUBLIC
934: -- Description:
935: -- Delete Validation.
936: -- This activity version may not be deleted if child rows in
937: -- ota_activity_versions exists where this activity version has superseded
938: -- another earlier activity version.
939: --
940: Procedure check_if_tav_exists
941: (

Line 958: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'

954: --
955: exception
956: when app_exception.application_exception then
957: if hr_multi_message.exception_add
958: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
959: ) then
960: hr_utility.set_location(' Leaving:'|| v_proc,70);
961: raise;
962: end if;

Line 993: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'

989: --
990: exception
991: when app_exception.application_exception then
992: if hr_multi_message.exception_add
993: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
994: ) then
995: hr_utility.set_location(' Leaving:'|| v_proc,70);
996: raise;
997: end if;

Line 1029: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION_UNITS'

1025: --
1026: exception
1027: when app_exception.application_exception then
1028: if hr_multi_message.exception_add
1029: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION_UNITS'
1030: ) then
1031: hr_utility.set_location(' Leaving:'|| v_proc,70);
1032: raise;
1033: end if;

Line 1063: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION'

1059: --
1060: exception
1061: when app_exception.application_exception then
1062: if hr_multi_message.exception_add
1063: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION'
1064: ) then
1065: hr_utility.set_location(' Leaving:'|| v_proc,70);
1066: raise;
1067: end if;

Line 1093: p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION'

1089: Exception
1090: WHEN app_exception.application_exception THEN
1091:
1092: IF hr_multi_message.exception_add(
1093: p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION'
1094: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.DURATION_UNITS')
1095: THEN
1096:
1097: --hr_utility.set_location(' Leaving:'||v_proc, 22);

Line 1094: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.DURATION_UNITS')

1090: WHEN app_exception.application_exception THEN
1091:
1092: IF hr_multi_message.exception_add(
1093: p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.DURATION'
1094: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.DURATION_UNITS')
1095: THEN
1096:
1097: --hr_utility.set_location(' Leaving:'||v_proc, 22);
1098: RAISE;

Line 1129: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.LANGUAGE_ID'

1125: --
1126: exception
1127: when app_exception.application_exception then
1128: if hr_multi_message.exception_add
1129: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.LANGUAGE_ID'
1130: ) then
1131: hr_utility.set_location(' Leaving:'|| v_proc,70);
1132: raise;
1133: end if;

Line 1166: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CONTROLLING_PERSON_ID'

1162: --
1163: exception
1164: when app_exception.application_exception then
1165: if hr_multi_message.exception_add
1166: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.CONTROLLING_PERSON_ID'
1167: ) then
1168: hr_utility.set_location(' Leaving:'|| v_proc,70);
1169: raise;
1170: end if;

Line 1209: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'

1205: --
1206: exception
1207: when app_exception.application_exception then
1208: if hr_multi_message.exception_add
1209: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
1210: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1211: ,p_associated_column3 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1212: ) then
1213: hr_utility.set_location(' Leaving:'|| v_proc,70);

Line 1210: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

1206: exception
1207: when app_exception.application_exception then
1208: if hr_multi_message.exception_add
1209: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
1210: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1211: ,p_associated_column3 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1212: ) then
1213: hr_utility.set_location(' Leaving:'|| v_proc,70);
1214: raise;

Line 1211: ,p_associated_column3 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

1207: when app_exception.application_exception then
1208: if hr_multi_message.exception_add
1209: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
1210: ,p_associated_column2 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1211: ,p_associated_column3 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1212: ) then
1213: hr_utility.set_location(' Leaving:'|| v_proc,70);
1214: raise;
1215: end if;

Line 1249: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_ID'

1245: --
1246: exception
1247: when app_exception.application_exception then
1248: if hr_multi_message.exception_add
1249: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_ID'
1250: ) then
1251: hr_utility.set_location(' Leaving:'|| v_proc,70);
1252: raise;
1253: end if;

Line 1295: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

1291:
1292: exception
1293: when app_exception.application_exception then
1294: if l_start_date_changed AND hr_multi_message.exception_add
1295: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1296: ) then
1297: hr_utility.set_location(' Leaving:'|| l_proc,70);
1298: raise;
1299: elsif l_end_date_changed AND hr_multi_message.exception_add

Line 1300: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

1296: ) then
1297: hr_utility.set_location(' Leaving:'|| l_proc,70);
1298: raise;
1299: elsif l_end_date_changed AND hr_multi_message.exception_add
1300: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1301: ) then
1302: hr_utility.set_location(' Leaving:'|| l_proc,80);
1303: raise;
1304: end if;

Line 1347: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'

1343:
1344: exception
1345: when app_exception.application_exception then
1346: if l_start_date_changed AND hr_multi_message.exception_add
1347: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.START_DATE'
1348: ) then
1349: hr_utility.set_location(' Leaving:'|| l_proc,70);
1350: raise;
1351: elsif l_end_date_changed AND hr_multi_message.exception_add

Line 1352: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.END_DATE'

1348: ) then
1349: hr_utility.set_location(' Leaving:'|| l_proc,70);
1350: raise;
1351: elsif l_end_date_changed AND hr_multi_message.exception_add
1352: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.END_DATE'
1353: ) then
1354: hr_utility.set_location(' Leaving:'|| l_proc,80);
1355: raise;
1356: end if;

Line 1411: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.COMPETENCY_UPDATE_LEVEL') THEN

1407:
1408: WHEN app_exception.application_exception THEN
1409:
1410: IF hr_multi_message.exception_add
1411: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.COMPETENCY_UPDATE_LEVEL') THEN
1412:
1413: hr_utility.set_location(' Leaving:'||l_proc, 30);
1414: RAISE;
1415: END IF;

Line 1896: ota_activity_versions oav,

1892: --
1893: cursor csr_leg_code is
1894: select legislation_code
1895: from per_business_groups pbg,
1896: ota_activity_versions oav,
1897: ota_activity_definitions oad
1898: where pbg.business_group_id = oad.business_group_id
1899: and oad.activity_id = oav.activity_id
1900: and oav.activity_version_id = p_activity_version_id;

Line 1960: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'

1956: --
1957: exception
1958: when app_exception.application_exception then
1959: if hr_multi_message.exception_add
1960: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
1961: ) then
1962: hr_utility.set_location(' Leaving:'|| v_proc,70);
1963: raise;
1964: end if;

Line 1997: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'

1993: --
1994: exception
1995: when app_exception.application_exception then
1996: if hr_multi_message.exception_add
1997: (p_associated_column1 => 'OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID'
1998: ) then
1999: hr_utility.set_location(' Leaving:'|| v_proc,70);
2000: raise;
2001: end if;