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_TAV_API_BUSINESS_RULES

Line 169: ota_tav_api_business_rules.check_min_max_values( p_min

165: Begin
166: --
167: hr_utility.set_location('Entering:'||v_proc, 5);
168: --
169: ota_tav_api_business_rules.check_min_max_values( p_min
170: , p_max );
171: --
172: hr_utility.set_location(' Leaving:'||v_proc, 10);
173: --

Line 208: ota_tav_api_business_rules.check_unique_name( p_business_group_id

204: Begin
205: --
206: hr_utility.set_location('Entering:'|| v_proc, 5);
207: --
208: ota_tav_api_business_rules.check_unique_name( p_business_group_id
209: , p_activity_id
210: , p_version_name
211: , p_activity_version_id);
212: --

Line 305: ota_tav_api_business_rules.check_superseding_version( p_sup_act_vers_id

301: Begin
302: --
303: hr_utility.set_location('Entering:'|| v_proc, 5);
304: --
305: ota_tav_api_business_rules.check_superseding_version( p_sup_act_vers_id
306: , p_end_date );
307: --
308: hr_utility.set_location(' Leaving:'|| v_proc, 10);
309: --

Line 340: ota_tav_api_business_rules.check_user_status( p_user_status );

336: Begin
337: --
338: hr_utility.set_location('Entering:'|| v_proc, 5);
339: --
340: ota_tav_api_business_rules.check_user_status( p_user_status );
341: --
342: hr_utility.set_location(' Leaving:'|| v_proc, 10);
343: --
344: exception

Line 374: ota_tav_api_business_rules.check_success_criteria( p_succ_criteria );

370: Begin
371: --
372: hr_utility.set_location('Entering:'|| v_proc, 5);
373: --
374: ota_tav_api_business_rules.check_success_criteria( p_succ_criteria );
375: --
376: hr_utility.set_location(' Leaving:'|| v_proc, 10);
377: --
378: exception

Line 410: Return ota_tav_api_business_rules.get_activity_version_id( p_activity_id

406: Begin
407: --
408: hr_utility.set_location('Entering:'|| v_proc, 5);
409: --
410: Return ota_tav_api_business_rules.get_activity_version_id( p_activity_id
411: , p_version_name );
412: --
413: hr_utility.set_location(' Leaving:'|| v_proc, 10);
414: --

Line 434: return ota_tav_api_business_rules.get_activity_version_name

430: v_proc varchar2(72) := g_package||'get_activity_version_name';
431: --
432: Begin
433: --
434: return ota_tav_api_business_rules.get_activity_version_name
435: ( p_activity_version_id );
436: --
437: End get_activity_version_name;
438: --

Line 460: ota_tav_api_business_rules.check_start_end_dates( p_start_date

456: Begin
457: --
458: hr_utility.set_location('Entering:'|| v_proc, 5);
459: --
460: ota_tav_api_business_rules.check_start_end_dates( p_start_date
461: , p_end_date );
462: --
463: hr_utility.set_location(' Leaving:'|| v_proc, 10);
464: --

Line 512: ota_tav_api_business_rules.check_dates_update_ple( p_activity_version_id

508:
509: --
510: hr_utility.set_location('Entering:'|| v_proc, 5);
511: --
512: ota_tav_api_business_rules.check_dates_update_ple( p_activity_version_id
513: , p_start_date
514: , p_end_date );
515: --
516: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 557: ota_tav_api_business_rules.check_dates_update_tbd( p_activity_version_id

553: ) then
554: --
555: hr_utility.set_location('Entering:'|| v_proc, 5);
556: --
557: ota_tav_api_business_rules.check_dates_update_tbd( p_activity_version_id
558: , p_start_date
559: , p_end_date );
560: --
561: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 605: ota_tav_api_business_rules.check_dates_update_evt( p_activity_version_id

601: ) then
602: --
603: hr_utility.set_location('Entering:'|| v_proc, 5);
604: --
605: ota_tav_api_business_rules.check_dates_update_evt( p_activity_version_id
606: , p_start_date
607: , p_end_date );
608: --
609: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 692: ota_tav_api_business_rules.check_if_evt_exists( p_activity_version_id );

688: Begin
689: --
690: hr_utility.set_location('Entering:'|| v_proc, 5);
691: --
692: ota_tav_api_business_rules.check_if_evt_exists( p_activity_version_id );
693: --
694: hr_utility.set_location(' Leaving:'|| v_proc, 10);
695: --
696: exception

Line 727: ota_tav_api_business_rules.check_if_off_exists( p_activity_version_id );

723: Begin
724: --
725: hr_utility.set_location('Entering:'|| v_proc, 5);
726: --
727: ota_tav_api_business_rules.check_if_off_exists( p_activity_version_id );
728: --
729: hr_utility.set_location(' Leaving:'|| v_proc, 10);
730: --
731: exception

Line 763: ota_tav_api_business_rules.check_if_tpm_exists( p_activity_version_id );

759: Begin
760: --
761: hr_utility.set_location('Entering:'|| v_proc, 5);
762: --
763: ota_tav_api_business_rules.check_if_tpm_exists( p_activity_version_id );
764: --
765: hr_utility.set_location(' Leaving:'|| v_proc, 10);
766: --
767: --

Line 801: ota_tav_api_business_rules.check_if_lpm_exists( p_activity_version_id );

797: Begin
798: --
799: hr_utility.set_location('Entering:'|| v_proc, 5);
800: --
801: ota_tav_api_business_rules.check_if_lpm_exists( p_activity_version_id );
802: --
803: hr_utility.set_location(' Leaving:'|| v_proc, 10);
804: --
805: --

Line 840: ota_tav_api_business_rules.check_if_tbd_exists( p_activity_version_id );

836: Begin
837: --
838: hr_utility.set_location('Entering:'|| v_proc, 5);
839: --
840: ota_tav_api_business_rules.check_if_tbd_exists( p_activity_version_id );
841: --
842: hr_utility.set_location(' Leaving:'|| v_proc, 10);
843: --
844: exception

Line 877: ota_tav_api_business_rules.check_if_ple_exists( p_activity_version_id );

873: Begin
874: --
875: hr_utility.set_location('Entering:'|| v_proc, 5);
876: --
877: ota_tav_api_business_rules.check_if_ple_exists( p_activity_version_id );
878: --
879: hr_utility.set_location(' Leaving:'|| v_proc, 10);
880: --
881: exception

Line 914: ota_tav_api_business_rules.check_if_comp_exists( p_activity_version_id );

910: Begin
911: --
912: hr_utility.set_location('Entering:'|| v_proc, 5);
913: --
914: ota_tav_api_business_rules.check_if_comp_exists( p_activity_version_id );
915: --
916: hr_utility.set_location(' Leaving:'|| v_proc, 10);
917: --
918: exception

Line 951: ota_tav_api_business_rules.check_if_tav_exists( p_activity_version_id );

947: Begin
948: --
949: hr_utility.set_location('Entering:'|| v_proc, 5);
950: --
951: ota_tav_api_business_rules.check_if_tav_exists( p_activity_version_id );
952: --
953: hr_utility.set_location(' Leaving:'|| v_proc, 10);
954: --
955: exception

Line 986: ota_tav_api_business_rules.check_if_tsp_exists( p_activity_version_id );

982: Begin
983: --
984: hr_utility.set_location('Entering:'|| v_proc, 5);
985: --
986: ota_tav_api_business_rules.check_if_tsp_exists( p_activity_version_id );
987: --
988: hr_utility.set_location(' Leaving:'|| v_proc, 10);
989: --
990: exception

Line 1022: ota_tav_api_business_rules.check_duration_units( p_duration_units );

1018: Begin
1019: --
1020: hr_utility.set_location('Entering:'|| v_proc, 5);
1021: --
1022: ota_tav_api_business_rules.check_duration_units( p_duration_units );
1023: --
1024: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1025: --
1026: exception

Line 1056: ota_tav_api_business_rules.check_duration( p_duration );

1052: Begin
1053: --
1054: hr_utility.set_location('Entering:'|| v_proc, 5);
1055: --
1056: ota_tav_api_business_rules.check_duration( p_duration );
1057: --
1058: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1059: --
1060: exception

Line 1122: ota_tav_api_business_rules.check_language( p_language_id );

1118: Begin
1119: --
1120: hr_utility.set_location('Entering:'|| v_proc, 5);
1121: --
1122: ota_tav_api_business_rules.check_language( p_language_id );
1123: --
1124: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1125: --
1126: exception

Line 1158: ota_tav_api_business_rules.check_controlling_person( p_person_id

1154: Begin
1155: --
1156: hr_utility.set_location('Entering:'|| v_proc, 5);
1157: --
1158: ota_tav_api_business_rules.check_controlling_person( p_person_id
1159: , p_date );
1160: --
1161: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1162: --

Line 1198: ota_tav_api_business_rules.check_multiple_con_version

1194: Begin
1195: --
1196: hr_utility.set_location('Entering:'|| v_proc, 5);
1197: --
1198: ota_tav_api_business_rules.check_multiple_con_version
1199: ( p_activity_id
1200: , p_activity_version_id
1201: , p_start_date
1202: , p_end_date);

Line 1242: ota_tav_api_business_rules.check_version_after_supersede( p_activity_id );

1238: Begin
1239: --
1240: hr_utility.set_location('Entering:'|| v_proc, 5);
1241: --
1242: ota_tav_api_business_rules.check_version_after_supersede( p_activity_id );
1243: --
1244: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1245: --
1246: exception

Line 1290: ota_tav_api_business_rules.check_course_lp_dates( p_activity_version_id, p_start_date, p_end_date );

1286:
1287: Begin
1288:
1289: hr_utility.set_location('Entering:'||l_proc, 5);
1290: ota_tav_api_business_rules.check_course_lp_dates( p_activity_version_id, p_start_date, p_end_date );
1291:
1292: exception
1293: when app_exception.application_exception then
1294: if l_start_date_changed AND hr_multi_message.exception_add

Line 1342: ota_tav_api_business_rules.check_course_crt_dates( p_activity_version_id, p_start_date, p_end_date );

1338:
1339: Begin
1340:
1341: hr_utility.set_location('Entering:'||l_proc, 5);
1342: ota_tav_api_business_rules.check_course_crt_dates( p_activity_version_id, p_start_date, p_end_date );
1343:
1344: exception
1345: when app_exception.application_exception then
1346: if l_start_date_changed AND hr_multi_message.exception_add

Line 1488: ota_tav_api_business_rules.check_Inventory_item_id(

1484: ,p_competency_update_level => p_rec.competency_update_level
1485: ,p_effective_date => trunc(sysdate));
1486:
1487: --
1488: ota_tav_api_business_rules.check_Inventory_item_id(
1489: p_rec.activity_version_id ,
1490: p_rec.inventory_item_id ,
1491: p_rec.organization_id );
1492: --

Line 1503: ota_tav_api_business_rules.check_vendor (p_rec.vendor_id);

1499: , p_rec.activity_version_id
1500: , p_rec.start_date
1501: , p_rec.end_date);
1502: --
1503: ota_tav_api_business_rules.check_vendor (p_rec.vendor_id);
1504: --
1505: ota_tav_api_business_rules.check_currency(p_rec.budget_currency_code);
1506: --
1507: ota_tav_api_business_rules.check_cost_vals

Line 1505: ota_tav_api_business_rules.check_currency(p_rec.budget_currency_code);

1501: , p_rec.end_date);
1502: --
1503: ota_tav_api_business_rules.check_vendor (p_rec.vendor_id);
1504: --
1505: ota_tav_api_business_rules.check_currency(p_rec.budget_currency_code);
1506: --
1507: ota_tav_api_business_rules.check_cost_vals
1508: (p_rec.budget_currency_code
1509: ,p_rec.budget_cost

Line 1507: ota_tav_api_business_rules.check_cost_vals

1503: ota_tav_api_business_rules.check_vendor (p_rec.vendor_id);
1504: --
1505: ota_tav_api_business_rules.check_currency(p_rec.budget_currency_code);
1506: --
1507: ota_tav_api_business_rules.check_cost_vals
1508: (p_rec.budget_currency_code
1509: ,p_rec.budget_cost
1510: ,p_rec.actual_cost);
1511: --

Line 1512: ota_tav_api_business_rules.check_professional_credit_vals

1508: (p_rec.budget_currency_code
1509: ,p_rec.budget_cost
1510: ,p_rec.actual_cost);
1511: --
1512: ota_tav_api_business_rules.check_professional_credit_vals
1513: (p_rec.professional_credit_type
1514: ,p_rec.professional_credits);
1515: --
1516: ota_tav_api_business_rules.check_professional_credit_type

Line 1516: ota_tav_api_business_rules.check_professional_credit_type

1512: ota_tav_api_business_rules.check_professional_credit_vals
1513: (p_rec.professional_credit_type
1514: ,p_rec.professional_credits);
1515: --
1516: ota_tav_api_business_rules.check_professional_credit_type
1517: (p_rec.professional_credit_type);
1518:
1519: /* For ILearning */
1520: ota_tav_api_business_rules.check_unique_rco_id

Line 1520: ota_tav_api_business_rules.check_unique_rco_id

1516: ota_tav_api_business_rules.check_professional_credit_type
1517: (p_rec.professional_credit_type);
1518:
1519: /* For ILearning */
1520: ota_tav_api_business_rules.check_unique_rco_id
1521: (p_rec.activity_version_id,
1522: p_rec.rco_id);
1523: --
1524: ota_tav_bus.chk_ddf(p_rec);

Line 1715: ota_tav_api_business_rules.check_dates_update_rud( p_rec.activity_version_id

1711: , p_rec.start_date
1712: , p_rec.end_date );
1713: --
1714: /*
1715: ota_tav_api_business_rules.check_dates_update_rud( p_rec.activity_version_id
1716: , p_rec.start_date
1717: , p_rec.end_date
1718: , ota_tav_shd.g_old_rec.start_date
1719: , ota_tav_shd.g_old_rec.end_date

Line 1754: ota_tav_api_business_rules.check_category_dates

1750: ,p_rec.start_date
1751: ,p_rec.end_date);
1752: End if;
1753: --
1754: ota_tav_api_business_rules.check_category_dates
1755: (
1756: p_activity_version_id => p_rec.activity_version_id
1757: ,p_start_date => p_rec.start_date
1758: ,p_end_date => p_rec.end_date

Line 1794: ota_tav_api_business_rules.check_vendor (p_rec.vendor_id);

1790: --
1791: End if;
1792: --
1793: if l_vendor_id_changed then
1794: ota_tav_api_business_rules.check_vendor (p_rec.vendor_id);
1795: end if;
1796: --
1797: if l_budget_currency_code_changed then
1798: ota_tav_api_business_rules.check_currency(p_rec.budget_currency_code);

Line 1798: ota_tav_api_business_rules.check_currency(p_rec.budget_currency_code);

1794: ota_tav_api_business_rules.check_vendor (p_rec.vendor_id);
1795: end if;
1796: --
1797: if l_budget_currency_code_changed then
1798: ota_tav_api_business_rules.check_currency(p_rec.budget_currency_code);
1799: end if;
1800: --
1801: if l_budget_currency_code_changed or
1802: l_budget_cost_changed or

Line 1804: ota_tav_api_business_rules.check_cost_vals

1800: --
1801: if l_budget_currency_code_changed or
1802: l_budget_cost_changed or
1803: l_actual_cost_changed then
1804: ota_tav_api_business_rules.check_cost_vals
1805: (p_rec.budget_currency_code
1806: ,p_rec.budget_cost
1807: ,p_rec.actual_cost);
1808: end if;

Line 1812: ota_tav_api_business_rules.check_professional_credit_vals

1808: end if;
1809: --
1810: if l_professional_ctype_changed or
1811: l_professional_credits_changed then
1812: ota_tav_api_business_rules.check_professional_credit_vals
1813: (p_rec.professional_credit_type
1814: ,p_rec.professional_credits);
1815: end if;
1816: --

Line 1818: ota_tav_api_business_rules.check_professional_credit_type

1814: ,p_rec.professional_credits);
1815: end if;
1816: --
1817: if l_professional_ctype_changed then
1818: ota_tav_api_business_rules.check_professional_credit_type
1819: (p_rec.professional_credit_type);
1820: end if;
1821: --
1822: if l_inventory_item_id_changed then

Line 1823: ota_tav_api_business_rules.check_Inventory_item_id(

1819: (p_rec.professional_credit_type);
1820: end if;
1821: --
1822: if l_inventory_item_id_changed then
1823: ota_tav_api_business_rules.check_Inventory_item_id(
1824: p_rec.activity_version_id ,
1825: p_rec.inventory_item_id ,
1826: p_rec.organization_id);
1827:

Line 1829: ota_tav_api_business_rules.check_oe_lines_exist(

1825: p_rec.inventory_item_id ,
1826: p_rec.organization_id);
1827:
1828:
1829: ota_tav_api_business_rules.check_oe_lines_exist(
1830: p_rec.activity_version_id ,
1831: p_rec.inventory_item_id ,
1832: p_rec.organization_id);
1833:

Line 1837: ota_tav_api_business_rules.check_unique_rco_id(

1833:
1834: end if;
1835: /* For ILearning */
1836: if l_rco_id_changed then
1837: ota_tav_api_business_rules.check_unique_rco_id(
1838: p_rec.activity_version_id ,
1839: p_rec.rco_id );
1840:
1841: end if;

Line 1953: ota_tav_api_business_rules.check_if_noth_exists( p_activity_version_id );

1949: Begin
1950: --
1951: hr_utility.set_location('Entering:'|| v_proc, 5);
1952: --
1953: ota_tav_api_business_rules.check_if_noth_exists( p_activity_version_id );
1954: --
1955: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1956: --
1957: exception

Line 1990: ota_tav_api_business_rules.check_if_crt_exists( p_activity_version_id );

1986: Begin
1987: --
1988: hr_utility.set_location('Entering:'|| v_proc, 5);
1989: --
1990: ota_tav_api_business_rules.check_if_crt_exists( p_activity_version_id );
1991: --
1992: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1993: --
1994: exception