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_CTU_BUS dependencies on OTA_CATEGORY_USAGES

Line 31: , ota_category_usages ctu

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , ota_category_usages ctu
32: where ctu.category_usage_id = p_category_usage_id
33: and pbg.business_group_id = ctu.business_group_id;
34: --
35: -- Declare local variables

Line 101: , ota_category_usages ctu

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , ota_category_usages ctu
102: where ctu.category_usage_id = p_category_usage_id
103: and pbg.business_group_id = ctu.business_group_id;
104: --
105: -- Declare local variables

Line 249: ,p_descflex_name => 'OTA_CATEGORY_USAGES'

245: -- b) During insert.
246: --
247: hr_dflex_utility.ins_or_upd_descflex_attribs
248: (p_appl_short_name => 'OTA'
249: ,p_descflex_name => 'OTA_CATEGORY_USAGES'
250: ,p_attribute_category => p_rec.attribute_category
251: ,p_attribute1_name => 'ATTRIBUTE1'
252: ,p_attribute1_value => p_rec.attribute1
253: ,p_attribute2_name => 'ATTRIBUTE2'

Line 318: ota_category_usages ctu

314: select
315: ctu.start_date_active,
316: nvl(ctu.end_date_active, hr_api.g_eot)
317: from
318: ota_category_usages ctu
319: where
320: ctu.category_usage_id = p_parent_cat_usage_id;
321: --
322: -- Variables for API Boolean parameters

Line 331: (p_check_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

327: Begin
328: hr_utility.set_location(' Entering:' || l_proc,10);
329: --
330: IF hr_multi_message.no_exclusive_error
331: (p_check_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
332: ,p_check_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
333: ,p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
334: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
335: ) THEN

Line 332: ,p_check_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'

328: hr_utility.set_location(' Entering:' || l_proc,10);
329: --
330: IF hr_multi_message.no_exclusive_error
331: (p_check_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
332: ,p_check_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
333: ,p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
334: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
335: ) THEN
336: --

Line 333: ,p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

329: --
330: IF hr_multi_message.no_exclusive_error
331: (p_check_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
332: ,p_check_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
333: ,p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
334: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
335: ) THEN
336: --
337: OPEN cur_par_cat_start_end_date;

Line 334: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'

330: IF hr_multi_message.no_exclusive_error
331: (p_check_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
332: ,p_check_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
333: ,p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
334: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
335: ) THEN
336: --
337: OPEN cur_par_cat_start_end_date;
338: FETCH cur_par_cat_start_end_date into l_par_cat_start_date, l_par_cat_end_date;

Line 359: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

355: hr_utility.set_location(' Leaving:' || l_proc,10);
356: Exception
357: when app_exception.application_exception then
358: IF hr_multi_message.exception_add
359: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
360: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
361: ) THEN
362: hr_utility.set_location(' Leaving:'|| l_proc,20);
363: raise;

Line 360: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'

356: Exception
357: when app_exception.application_exception then
358: IF hr_multi_message.exception_add
359: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
360: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
361: ) THEN
362: hr_utility.set_location(' Leaving:'|| l_proc,20);
363: raise;
364: END IF;

Line 389: ota_category_usages ccat

385: select
386: ccat.start_date_active,
387: ccat.end_date_active
388: from
389: ota_category_usages ccat
390: where
391: ccat.parent_cat_usage_id = p_category_usage_id;
392: --
393: -- Variables for API Boolean parameters

Line 395: v_start_date ota_category_usages.start_date_active%TYPE;

391: ccat.parent_cat_usage_id = p_category_usage_id;
392: --
393: -- Variables for API Boolean parameters
394: l_proc varchar2(72) := g_package ||'Chk_Child_Category_Dates';
395: v_start_date ota_category_usages.start_date_active%TYPE;
396: v_end_date ota_category_usages.end_date_active%TYPE;
397: l_obj_cat varchar2(80);
398: l_obj_child_cat varchar2(80);
399:

Line 396: v_end_date ota_category_usages.end_date_active%TYPE;

392: --
393: -- Variables for API Boolean parameters
394: l_proc varchar2(72) := g_package ||'Chk_Child_Category_Dates';
395: v_start_date ota_category_usages.start_date_active%TYPE;
396: v_end_date ota_category_usages.end_date_active%TYPE;
397: l_obj_cat varchar2(80);
398: l_obj_child_cat varchar2(80);
399:
400: Begin

Line 441: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

437: hr_utility.set_location(' Leaving:' || l_proc,10);
438: Exception
439: when app_exception.application_exception then
440: IF hr_multi_message.exception_add
441: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
442: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
443: ) THEN
444: hr_utility.set_location(' Leaving:'|| l_proc,20);
445: raise;

Line 442: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'

438: Exception
439: when app_exception.application_exception then
440: IF hr_multi_message.exception_add
441: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
442: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
443: ) THEN
444: hr_utility.set_location(' Leaving:'|| l_proc,20);
445: raise;
446: END IF;

Line 534: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

530: hr_utility.set_location(' Leaving:' || l_proc,10);
531: Exception
532: when app_exception.application_exception then
533: IF hr_multi_message.exception_add
534: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
535: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
536: ) THEN
537: hr_utility.set_location(' Leaving:'|| l_proc,20);
538: raise;

Line 535: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'

531: Exception
532: when app_exception.application_exception then
533: IF hr_multi_message.exception_add
534: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
535: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
536: ) THEN
537: hr_utility.set_location(' Leaving:'|| l_proc,20);
538: raise;
539: END IF;

Line 627: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

623: hr_utility.set_location(' Leaving:' || l_proc,10);
624: Exception
625: when app_exception.application_exception then
626: IF hr_multi_message.exception_add
627: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
628: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
629: ) THEN
630: hr_utility.set_location(' Leaving:'|| l_proc,20);
631: raise;

Line 628: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'

624: Exception
625: when app_exception.application_exception then
626: IF hr_multi_message.exception_add
627: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
628: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
629: ) THEN
630: hr_utility.set_location(' Leaving:'|| l_proc,20);
631: raise;
632: END IF;

Line 653: ota_category_usages ctu

649: CURSOR cur_root_category is
650: select
651: distinct 'found'
652: From
653: ota_category_usages ctu
654: where
655: ctu.business_group_id = p_business_group_id
656: and ctu.parent_cat_usage_id is null
657: and ctu.type = 'C';

Line 683: (p_associated_column1 => 'OTA_CATEGORY_USAGES.BUSINESS_GROUP_ID'

679: hr_utility.set_location(' Leaving:' || l_proc,10);
680: Exception
681: when app_exception.application_exception then
682: IF hr_multi_message.exception_add
683: (p_associated_column1 => 'OTA_CATEGORY_USAGES.BUSINESS_GROUP_ID'
684: ) THEN
685: hr_utility.set_location(' Leaving:'|| l_proc,20);
686: raise;
687: END IF;

Line 771: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

767: hr_utility.set_location(' Leaving:' || l_proc,10);
768: Exception
769: when app_exception.application_exception then
770: IF hr_multi_message.exception_add
771: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
772: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
773: ) THEN
774: hr_utility.set_location(' Leaving:'|| l_proc,20);
775: raise;

Line 772: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'

768: Exception
769: when app_exception.application_exception then
770: IF hr_multi_message.exception_add
771: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
772: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.END_DATE_ACTIVE'
773: ) THEN
774: hr_utility.set_location(' Leaving:'|| l_proc,20);
775: raise;
776: END IF;

Line 826: (p_associated_column1 => 'OTA_CATEGORY_USAGES.ONLINE_FLAG'

822: --
823: Exception
824: when app_exception.application_exception then
825: IF hr_multi_message.exception_add
826: (p_associated_column1 => 'OTA_CATEGORY_USAGES.ONLINE_FLAG'
827: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.SYNCHRONOUS_FLAG'
828: ) THEN
829: hr_utility.set_location(' Leaving:'|| l_proc,20);
830: raise;

Line 827: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.SYNCHRONOUS_FLAG'

823: Exception
824: when app_exception.application_exception then
825: IF hr_multi_message.exception_add
826: (p_associated_column1 => 'OTA_CATEGORY_USAGES.ONLINE_FLAG'
827: ,p_associated_column2 => 'OTA_CATEGORY_USAGES.SYNCHRONOUS_FLAG'
828: ) THEN
829: hr_utility.set_location(' Leaving:'|| l_proc,20);
830: raise;
831: END IF;

Line 911: ota_category_usages_vl ctu

907: cursor csr_cat_name is
908: select
909: distinct ctu.type
910: from
911: ota_category_usages_vl ctu
912: where
913: ctu.category = p_category
914: and (p_category_usage_id is null or ctu.category_usage_id <> p_category_usage_id)
915: and (ctu.parent_cat_usage_id = p_parent_cat_usage_id or ctu.type <> 'C')

Line 1168: ota_category_usages ctu

1164: CURSOR cur_category_type is
1165: select
1166: ctu.type
1167: From
1168: ota_category_usages ctu
1169: where
1170: ctu.category_usage_id = p_rec.category_usage_id;
1171: --
1172: l_proc varchar2(72) := g_package||'delete_validate';

Line 1233: ota_category_usages ctu1

1229: CURSOR cur_parent_categories is
1230: select
1231: '1' Cat_exists
1232: From
1233: ota_category_usages ctu1
1234: where
1235: ctu1.category_usage_id = p_category_usage_id
1236: and ctu1.category_usage_id in
1237: (select

Line 1240: ota_category_usages ctu2

1236: and ctu1.category_usage_id in
1237: (select
1238: ctu2.parent_cat_usage_id
1239: From
1240: ota_category_usages ctu2
1241: connect by ctu2.category_usage_id = prior ctu2.parent_cat_usage_id
1242: start with ctu2.category_usage_id = p_parent_cat_usage_id
1243: );
1244:

Line 1277: (p_associated_column1 => 'OTA_CATEGORY_USAGES_TL.CATEGORY'

1273: hr_utility.set_location(' Leaving:'||l_proc, 10);
1274: Exception
1275: when app_exception.application_exception then
1276: IF hr_multi_message.exception_add
1277: (p_associated_column1 => 'OTA_CATEGORY_USAGES_TL.CATEGORY'
1278: ) THEN
1279: hr_utility.set_location(' Leaving:'|| l_proc,20);
1280: raise;
1281: END IF;

Line 1301: ota_category_usages ctu

1297: CURSOR cur_child_categories is
1298: select
1299: distinct 'found'
1300: From
1301: ota_category_usages ctu
1302: where
1303: parent_cat_usage_id = p_category_usage_id;
1304:
1305: -- Variables for API Boolean parameters

Line 1331: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'

1327:
1328: Exception
1329: when app_exception.application_exception then
1330: IF hr_multi_message.exception_add
1331: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'
1332: ,p_same_associated_columns => 'Y'
1333: ) THEN
1334: hr_utility.set_location(' Leaving:'|| l_proc,20);
1335: raise;

Line 1386: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'

1382: hr_utility.set_location(' Leaving:' || l_proc,10);
1383: Exception
1384: when app_exception.application_exception then
1385: IF hr_multi_message.exception_add
1386: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'
1387: ,p_same_associated_columns => 'Y'
1388: ) THEN
1389: hr_utility.set_location(' Leaving:'|| l_proc,20);
1390: raise;

Line 1468: (p_associated_column1 => 'OTA_CATEGORY_USAGES.ONLINE_FLAG'

1464: --
1465: Exception
1466: when app_exception.application_exception then
1467: if hr_multi_message.exception_add
1468: (p_associated_column1 => 'OTA_CATEGORY_USAGES.ONLINE_FLAG'
1469: ) then
1470: hr_utility.set_location(' Leaving:'|| l_proc,20);
1471: raise;
1472: end if;

Line 1507: (p_associated_column1 => 'OTA_CATEGORY_USAGES.SYNCHRONOUS_FLAG'

1503: --
1504: Exception
1505: when app_exception.application_exception then
1506: if hr_multi_message.exception_add
1507: (p_associated_column1 => 'OTA_CATEGORY_USAGES.SYNCHRONOUS_FLAG'
1508: ) then
1509: hr_utility.set_location(' Leaving:'|| l_proc,70);
1510: raise;
1511: end if;

Line 1549: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'

1545: --
1546: Exception
1547: when app_exception.application_exception then
1548: IF hr_multi_message.exception_add
1549: (p_associated_column1 => 'OTA_CATEGORY_USAGES.START_DATE_ACTIVE'
1550: ) THEN
1551: hr_utility.set_location(' Leaving:'|| l_proc,20);
1552: raise;
1553: END IF;

Line 1602: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'

1598: hr_utility.set_location(' Leaving:' || l_proc,10);
1599: Exception
1600: when app_exception.application_exception then
1601: IF hr_multi_message.exception_add
1602: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'
1603: ,p_same_associated_columns => 'Y'
1604: ) THEN
1605: hr_utility.set_location(' Leaving:'|| l_proc,20);
1606: raise;

Line 1630: ota_category_usages ctu

1626: distinct tad.name
1627: From
1628: ota_training_plan_members tpm,
1629: ota_activity_definitions_vl tad,
1630: ota_category_usages ctu
1631: where
1632: ctu.category_usage_id = tad.category_usage_id
1633: and tad.activity_id = tpm.activity_definition_id
1634: and ctu.category_usage_id = p_category_usage_id;

Line 1660: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'

1656: hr_utility.set_location(' Leaving:' || l_proc,10);
1657: Exception
1658: when app_exception.application_exception then
1659: IF hr_multi_message.exception_add
1660: (p_associated_column1 => 'OTA_CATEGORY_USAGES.CATEGORY'
1661: ,p_same_associated_columns => 'Y'
1662: ) THEN
1663: hr_utility.set_location(' Leaving:'|| l_proc,20);
1664: raise;