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_TPS_BUS dependencies on OTA_TPS_BUS

Line 1: PACKAGE BODY OTA_TPS_BUS AS

1: PACKAGE BODY OTA_TPS_BUS AS
2: /* $Header: ottpsrhi.pkb 120.2 2005/12/14 15:17:58 asud noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33) := ' ota_tps_bus.'; -- Global package name

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ota_tps_bus.'; -- Global package name
9: --
10: -- The following two global variables are only to be
11: -- used by the return_legislation_code function.
12: --

Line 118: IF ( NVL(ota_tps_bus.g_training_plan_id, hr_api.g_number)

114: ,p_argument => 'training_plan_id'
115: ,p_argument_value => p_training_plan_id
116: );
117: --
118: IF ( NVL(ota_tps_bus.g_training_plan_id, hr_api.g_number)
119: = p_training_plan_id) THEN
120: --
121: -- The legislation code has already been found with a previous
122: -- call to this function. Just return the value in the global

Line 125: l_legislation_code := ota_tps_bus.g_legislation_code;

121: -- The legislation code has already been found with a previous
122: -- call to this function. Just return the value in the global
123: -- variable.
124: --
125: l_legislation_code := ota_tps_bus.g_legislation_code;
126: hr_utility.set_location(l_proc, 20);
127: ELSE
128: --
129: -- The ID is different to the last call to this function

Line 149: ota_tps_bus.g_training_plan_id := p_training_plan_id;

145: -- Set the global variables so the values are
146: -- available for the next call to this function.
147: --
148: CLOSE csr_leg_code;
149: ota_tps_bus.g_training_plan_id := p_training_plan_id;
150: ota_tps_bus.g_legislation_code := l_legislation_code;
151: END IF;
152: hr_utility.set_location(' Leaving:'|| l_proc, 40);
153: RETURN l_legislation_code;

Line 150: ota_tps_bus.g_legislation_code := l_legislation_code;

146: -- available for the next call to this function.
147: --
148: CLOSE csr_leg_code;
149: ota_tps_bus.g_training_plan_id := p_training_plan_id;
150: ota_tps_bus.g_legislation_code := l_legislation_code;
151: END IF;
152: hr_utility.set_location(' Leaving:'|| l_proc, 40);
153: RETURN l_legislation_code;
154: END return_legislation_code;

Line 450: ota_tps_bus1.chk_org_person (

446: hr_multi_message.end_validation_set;
447:
448: --
449: hr_utility.set_location(' Step:'|| l_proc, 20);
450: ota_tps_bus1.chk_org_person (
451: p_organization_id => p_rec.organization_id
452: ,p_person_id => p_rec.person_id
453: ,p_contact_id => p_rec.contact_id);
454: --

Line 456: ota_tps_bus1.chk_organization_id (

452: ,p_person_id => p_rec.person_id
453: ,p_contact_id => p_rec.contact_id);
454: --
455: hr_utility.set_location(' Step:'|| l_proc, 30);
456: ota_tps_bus1.chk_organization_id (
457: p_organization_id => p_rec.organization_id
458: ,p_business_group_id => p_rec.business_group_id);
459: --
460: hr_utility.set_location(' Step:'|| l_proc, 40);

Line 461: ota_tps_bus1.chk_person_id (

457: p_organization_id => p_rec.organization_id
458: ,p_business_group_id => p_rec.business_group_id);
459: --
460: hr_utility.set_location(' Step:'|| l_proc, 40);
461: ota_tps_bus1.chk_person_id (
462: p_effective_date => p_effective_date
463: ,p_person_id => p_rec.person_id
464: ,p_business_group_id => p_rec.business_group_id);
465: --

Line 472: ota_tps_bus1.chk_plan_status_type_id (

468: IF p_rec.person_id IS NOT NULL OR p_rec.contact_id IS NOT NULL THEN
469: OTA_TRNG_PLAN_UTIL_SS.g_is_per_trng_plan := TRUE;
470: END IF;
471:
472: ota_tps_bus1.chk_plan_status_type_id (
473: p_effective_date => p_effective_date
474: ,p_plan_status_type_id => p_rec.plan_status_type_id);
475: --
476: hr_utility.set_location(' Step:'|| l_proc, 80);

Line 477: ota_tps_bus1.chk_currency_code (

473: p_effective_date => p_effective_date
474: ,p_plan_status_type_id => p_rec.plan_status_type_id);
475: --
476: hr_utility.set_location(' Step:'|| l_proc, 80);
477: ota_tps_bus1.chk_currency_code (
478: p_budget_currency => p_rec.budget_currency
479: ,p_training_plan_id => p_rec.training_plan_id
480: ,p_business_group_id => p_rec.business_group_id
481: ,p_object_version_number => p_rec.object_version_number);

Line 485: ota_tps_bus1.chk_name

481: ,p_object_version_number => p_rec.object_version_number);
482: --
483: IF p_rec.learning_path_id IS NULL THEN
484: hr_utility.set_location(' Step:'|| l_proc, 90);
485: ota_tps_bus1.chk_name
486: (p_name => p_rec.name
487: ,p_training_plan_id => p_rec.training_plan_id
488: ,p_person_id => p_rec.person_id --Bug#3484692
489: ,p_contact_id => p_rec.contact_id --Bug#3855813

Line 498: ota_tps_bus1.chk_tp_date_range

494: IF p_rec.person_id IS NOT NULL OR p_rec.contact_id IS NOT NULL THEN
495: hr_utility.set_location(' Step:'|| l_proc, 55);
496:
497:
498: ota_tps_bus1.chk_tp_date_range
499: (p_training_plan_id => p_rec.training_plan_id
500: ,p_start_date => p_rec.start_date
501: ,p_end_date => p_rec.end_date
502: ,p_object_version_number => p_rec.object_version_number);

Line 504: ota_tps_bus1.chk_plan_source(

500: ,p_start_date => p_rec.start_date
501: ,p_end_date => p_rec.end_date
502: ,p_object_version_number => p_rec.object_version_number);
503:
504: ota_tps_bus1.chk_plan_source(
505: p_effective_date => p_effective_date
506: ,p_plan_source => p_rec.plan_source
507: ,p_training_plan_id => p_rec.training_plan_id);
508:

Line 511: ota_tps_bus1.chk_time_period_id (

507: ,p_training_plan_id => p_rec.training_plan_id);
508:
509: ELSIF p_rec.person_id IS NULL AND p_rec.contact_id IS NULL THEN
510: hr_utility.set_location(' Step:'|| l_proc, 60);
511: ota_tps_bus1.chk_time_period_id (
512: p_training_plan_id => p_rec.training_plan_id
513: ,p_object_version_number => p_rec.object_version_number
514: ,p_time_period_id => p_rec.time_period_id
515: ,p_business_group_id => p_rec.business_group_id);

Line 518: ota_tps_bus1.chk_unique (

514: ,p_time_period_id => p_rec.time_period_id
515: ,p_business_group_id => p_rec.business_group_id);
516: --
517:
518: ota_tps_bus1.chk_unique (
519: p_training_plan_id => p_rec.training_plan_id
520: ,p_object_version_number => p_rec.object_version_number
521: ,p_organization_id => p_rec.organization_id
522: ,p_person_id => p_rec.person_id

Line 526: ota_tps_bus1.chk_period_overlap (

522: ,p_person_id => p_rec.person_id
523: ,p_time_period_id => p_rec.time_period_id );
524:
525: hr_utility.set_location(' Step:'|| l_proc, 70);
526: ota_tps_bus1.chk_period_overlap (
527: p_training_plan_id => p_rec.training_plan_id
528: ,p_object_version_number => p_rec.object_version_number
529: ,p_plan_status_type_id => p_rec.plan_status_type_id
530: ,p_time_period_id => p_rec.time_period_id

Line 537: ota_tps_bus.chk_df(p_rec);

533: --
534: END IF;
535:
536: --
537: ota_tps_bus.chk_df(p_rec);
538: --
539: hr_utility.set_location(' Leaving:'||l_proc, 100);
540: END insert_validate;
541: --

Line 573: ota_tps_bus1.chk_plan_status_type_id (

569: hr_utility.set_location(' Step:'|| l_proc, 10);
570: -- Set the Is_Per_Trng_Plan global variable
571: l_boolean := OTA_TRNG_PLAN_UTIL_SS.is_personal_trng_plan(p_rec.training_plan_id);
572:
573: ota_tps_bus1.chk_plan_status_type_id (
574: p_effective_date => p_effective_date
575: ,p_plan_status_type_id => p_rec.plan_status_type_id);
576: --
577: hr_utility.set_location(' Step:'|| l_proc, 40);

Line 579: ota_tps_bus1.chk_currency_code (

575: ,p_plan_status_type_id => p_rec.plan_status_type_id);
576: --
577: hr_utility.set_location(' Step:'|| l_proc, 40);
578:
579: ota_tps_bus1.chk_currency_code (
580: p_budget_currency => p_rec.budget_currency
581: ,p_training_plan_id => p_rec.training_plan_id
582: ,p_business_group_id => p_rec.business_group_id
583: ,p_object_version_number => p_rec.object_version_number);

Line 587: ota_tps_bus1.chk_name (

583: ,p_object_version_number => p_rec.object_version_number);
584: --
585: hr_utility.set_location(' Step:'|| l_proc, 50);
586:
587: ota_tps_bus1.chk_name (
588: p_name => p_rec.name
589: ,p_training_plan_id => p_rec.training_plan_id
590: ,p_person_id => p_rec.person_id --Bug#3484692
591: ,p_contact_id => p_rec.contact_id --Bug#3855813

Line 599: ota_tps_bus1.chk_tp_date_range

595:
596: IF p_rec.person_id IS NOT NULL OR p_rec.contact_id IS NOT NULL THEN
597: hr_utility.set_location(' Step:'|| l_proc, 15);
598:
599: ota_tps_bus1.chk_tp_date_range
600: (p_training_plan_id => p_rec.training_plan_id
601: ,p_start_date => p_rec.start_date
602: ,p_end_date => p_rec.end_date
603: ,p_object_version_number => p_rec.object_version_number);

Line 605: ota_tps_bus1.chk_plan_source(

601: ,p_start_date => p_rec.start_date
602: ,p_end_date => p_rec.end_date
603: ,p_object_version_number => p_rec.object_version_number);
604:
605: ota_tps_bus1.chk_plan_source(
606: p_effective_date => p_effective_date
607: ,p_plan_source => p_rec.plan_source
608: ,p_training_plan_id => p_rec.training_plan_id);
609:

Line 614: ota_tps_bus1.chk_time_period_id (

610: END IF;
611: --
612: IF p_rec.person_id IS NULL AND p_rec.contact_id IS NULL THEN
613: hr_utility.set_location(' Step:'|| l_proc, 20);
614: ota_tps_bus1.chk_time_period_id (
615: p_training_plan_id => p_rec.training_plan_id
616: ,p_object_version_number => p_rec.object_version_number
617: ,p_time_period_id => p_rec.time_period_id
618: ,p_business_group_id => p_rec.business_group_id);

Line 622: ota_tps_bus1.chk_unique (

618: ,p_business_group_id => p_rec.business_group_id);
619: --
620: hr_utility.set_location(' Step:'|| l_proc, 30);
621:
622: ota_tps_bus1.chk_unique (
623: p_training_plan_id => p_rec.training_plan_id
624: ,p_object_version_number => p_rec.object_version_number
625: ,p_organization_id => p_rec.organization_id
626: ,p_person_id => p_rec.person_id

Line 630: ota_tps_bus1.chk_period_overlap (

626: ,p_person_id => p_rec.person_id
627: ,p_time_period_id => p_rec.time_period_id );
628:
629:
630: ota_tps_bus1.chk_period_overlap (
631: p_training_plan_id => p_rec.training_plan_id
632: ,p_object_version_number => p_rec.object_version_number
633: ,p_plan_status_type_id => p_rec.plan_status_type_id
634: ,p_time_period_id => p_rec.time_period_id

Line 640: ota_tps_bus.chk_df(p_rec);

636: ,p_organization_id => p_rec.organization_id);
637: END IF;
638:
639: hr_utility.set_location(' Step:'|| l_proc, 60);
640: ota_tps_bus.chk_df(p_rec);
641: --
642: hr_utility.set_location(' Leaving:'||l_proc, 70);
643: END update_validate;
644: --

Line 660: ota_tps_bus1.chk_del_training_plan_id(

656: --
657: -- Call all supporting business operations
658: --
659: hr_utility.set_location(' Step:'|| l_proc, 10);
660: ota_tps_bus1.chk_del_training_plan_id(
661: p_training_plan_id => ota_tps_shd.g_old_rec.training_plan_id);
662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 20);
664: END delete_validate;

Line 666: END ota_tps_bus;

662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 20);
664: END delete_validate;
665: --
666: END ota_tps_bus;