DBA Data[Home] [Help]

APPS.OTA_TPM_BUS dependencies on OTA_TPM_BUS1

Line 430: ota_tpm_bus1.chk_training_plan_id(

426: hr_multi_message.end_validation_set;
427: --
428: --
429: hr_utility.set_location(' Step:'|| l_proc, 10);
430: ota_tpm_bus1.chk_training_plan_id(
431: p_training_plan_id => p_rec.training_plan_id
432: ,p_business_group_id => p_rec.business_group_id);
433: --
434:

Line 436: ota_tpm_bus1.chk_member_status_type_id(

432: ,p_business_group_id => p_rec.business_group_id);
433: --
434:
435: hr_utility.set_location(' Step:'|| l_proc, 20);
436: ota_tpm_bus1.chk_member_status_type_id(
437: p_effective_date => p_effective_date
438: ,p_member_status_type_id => p_rec.member_status_type_id
439: ,p_business_group_id => p_rec.business_group_id
440: ,p_training_plan_member_id => p_rec.training_plan_member_id

Line 449: ota_tpm_bus1.chk_version_definition(

445: ,p_target_completion_date => p_rec.target_completion_date);
446: --
447:
448: hr_utility.set_location(' Step:'|| l_proc, 30);
449: ota_tpm_bus1.chk_version_definition(
450: p_training_plan_member_id => p_rec.training_plan_member_id
451: ,p_object_version_number => p_rec.object_version_number
452: ,p_activity_definition_id => p_rec.activity_definition_id
453: ,p_activity_version_id => p_rec.activity_version_id

Line 459: ota_tpm_bus1.chk_activity_version_id (

455: ,p_business_group_id => p_rec.business_group_id);
456:
457: --
458: hr_utility.set_location(' Step:'|| l_proc, 40);
459: ota_tpm_bus1.chk_activity_version_id (
460: p_training_plan_member_id => p_rec.training_plan_member_id
461: ,p_object_version_number => p_rec.object_version_number
462: ,p_activity_version_id => p_rec.activity_version_id
463: ,p_training_plan_id => p_rec.training_plan_id

Line 476: ota_tpm_bus1.chk_activity_definition_id (

472: -- IF l_person_id = 0 THEN
473: IF NOT l_personal_trng_plan THEN
474:
475: hr_utility.set_location(' Step:'|| l_proc, 50);
476: ota_tpm_bus1.chk_activity_definition_id (
477: p_training_plan_member_id => p_rec.training_plan_member_id
478: ,p_object_version_number => p_rec.object_version_number
479: ,p_activity_definition_id => p_rec.activity_definition_id
480: ,p_business_group_id => p_rec.business_group_id);

Line 483: ota_tpm_bus1.chk_unique(

479: ,p_activity_definition_id => p_rec.activity_definition_id
480: ,p_business_group_id => p_rec.business_group_id);
481:
482: hr_utility.set_location(' Step:'|| l_proc, 60);
483: ota_tpm_bus1.chk_unique(
484: p_training_plan_member_id => p_rec.training_plan_member_id
485: ,p_object_version_number => p_rec.object_version_number
486: ,p_activity_definition_id => p_rec.activity_definition_id
487: ,p_activity_version_id => p_rec.activity_version_id

Line 491: ota_tpm_bus1.chk_source_function(

487: ,p_activity_version_id => p_rec.activity_version_id
488: ,p_training_plan_id => p_rec.training_plan_id);
489: ELSE
490: hr_utility.set_location(' Step:'|| l_proc, 70);
491: ota_tpm_bus1.chk_source_function(
492: p_training_plan_member_id => p_rec.training_plan_member_id
493: ,p_source_function => p_rec.source_function
494: ,p_effective_date => p_effective_date);
495:

Line 497: ota_tpm_bus1.chk_cancellation_reason(

493: ,p_source_function => p_rec.source_function
494: ,p_effective_date => p_effective_date);
495:
496: hr_utility.set_location(' Step:'|| l_proc, 80);
497: ota_tpm_bus1.chk_cancellation_reason(
498: p_training_plan_member_id => p_rec.training_plan_member_id
499: ,p_cancellation_reason => p_rec.cancellation_reason
500: ,p_effective_date => p_effective_date);
501:

Line 503: ota_tpm_bus1.chk_tpc_tp_actver_dates

499: ,p_cancellation_reason => p_rec.cancellation_reason
500: ,p_effective_date => p_effective_date);
501:
502: hr_utility.set_location(' Step:'|| l_proc, 90);
503: ota_tpm_bus1.chk_tpc_tp_actver_dates
504: (p_training_plan_id => p_rec.training_plan_id
505: ,p_training_plan_member_id => p_rec.training_plan_member_id
506: ,p_activity_version_id => p_rec.activity_version_id
507: ,p_earliest_start_date => p_rec.earliest_start_date

Line 512: ota_tpm_bus1.chk_unique1(

508: ,p_target_completion_date =>p_rec.target_completion_date
509: ,p_object_version_number =>p_rec.object_version_number);
510:
511: hr_utility.set_location(' Step:'|| l_proc, 100);
512: ota_tpm_bus1.chk_unique1(
513: p_training_plan_member_id => p_rec.training_plan_member_id
514: ,p_object_version_number => p_rec.object_version_number
515: ,p_activity_definition_id => p_rec.activity_definition_id
516: ,p_activity_version_id => p_rec.activity_version_id

Line 568: ota_tpm_bus1.chk_activity_definition_id (

564: l_personal_trng_plan := ota_trng_plan_util_ss.is_personal_trng_plan(p_training_plan_id => p_rec.training_plan_id);
565:
566:
567: hr_utility.set_location(' Step:'|| l_proc, 10);
568: ota_tpm_bus1.chk_activity_definition_id (
569: p_training_plan_member_id => p_rec.training_plan_member_id
570: ,p_object_version_number => p_rec.object_version_number
571: ,p_activity_definition_id => p_rec.activity_definition_id
572: ,p_business_group_id => p_rec.business_group_id);

Line 575: ota_tpm_bus1.chk_member_status_type_id(

571: ,p_activity_definition_id => p_rec.activity_definition_id
572: ,p_business_group_id => p_rec.business_group_id);
573: --
574: hr_utility.set_location(' Step:'|| l_proc, 20);
575: ota_tpm_bus1.chk_member_status_type_id(
576: p_effective_date => p_effective_date
577: ,p_member_status_type_id => p_rec.member_status_type_id
578: ,p_business_group_id => p_rec.business_group_id
579: ,p_training_plan_member_id => p_rec.training_plan_member_id

Line 587: ota_tpm_bus1.chk_version_definition(

583: ,p_training_plan_id => p_rec.training_plan_id
584: ,p_target_completion_date => p_rec.target_completion_date);
585: --
586: hr_utility.set_location(' Step:'|| l_proc, 30);
587: ota_tpm_bus1.chk_version_definition(
588: p_training_plan_member_id => p_rec.training_plan_member_id
589: ,p_object_version_number => p_rec.object_version_number
590: ,p_activity_definition_id => p_rec.activity_definition_id
591: ,p_activity_version_id => p_rec.activity_version_id

Line 596: ota_tpm_bus1.chk_activity_version_id (

592: ,p_training_plan_id => p_rec.training_plan_id
593: ,p_business_group_id => p_rec.business_group_id);
594: --
595: hr_utility.set_location(' Step:'|| l_proc, 40);
596: ota_tpm_bus1.chk_activity_version_id (
597: p_training_plan_member_id => p_rec.training_plan_member_id
598: ,p_object_version_number => p_rec.object_version_number
599: ,p_activity_version_id => p_rec.activity_version_id
600: ,p_training_plan_id => p_rec.training_plan_id

Line 608: ota_tpm_bus1.chk_source_function(

604: -- IF l_person_id <> 0 THEN
605: IF l_personal_trng_plan THEN
606:
607: hr_utility.set_location(' Step:'|| l_proc, 50);
608: ota_tpm_bus1.chk_source_function(
609: p_training_plan_member_id => p_rec.training_plan_member_id
610: ,p_source_function => p_rec.source_function
611: ,p_effective_date => p_effective_date);
612:

Line 614: ota_tpm_bus1.chk_cancellation_reason(

610: ,p_source_function => p_rec.source_function
611: ,p_effective_date => p_effective_date);
612:
613: hr_utility.set_location(' Step:'|| l_proc, 60);
614: ota_tpm_bus1.chk_cancellation_reason(
615: p_training_plan_member_id => p_rec.training_plan_member_id
616: ,p_cancellation_reason => p_rec.cancellation_reason
617: ,p_effective_date => p_effective_date);
618:

Line 620: ota_tpm_bus1.chk_tpc_tp_actver_dates

616: ,p_cancellation_reason => p_rec.cancellation_reason
617: ,p_effective_date => p_effective_date);
618:
619: hr_utility.set_location(' Step:'|| l_proc, 70);
620: ota_tpm_bus1.chk_tpc_tp_actver_dates
621: (p_training_plan_id => p_rec.training_plan_id
622: ,p_training_plan_member_id => p_rec.training_plan_member_id
623: ,p_activity_version_id => p_rec.activity_version_id
624: ,p_earliest_start_date => p_rec.earliest_start_date

Line 629: ota_tpm_bus1.chk_unique1(

625: ,p_target_completion_date =>p_rec.target_completion_date
626: ,p_object_version_number =>p_rec.object_version_number);
627:
628: hr_utility.set_location(' Step:'|| l_proc, 80);
629: ota_tpm_bus1.chk_unique1(
630: p_training_plan_member_id => p_rec.training_plan_member_id
631: ,p_object_version_number => p_rec.object_version_number
632: ,p_activity_definition_id => p_rec.activity_definition_id
633: ,p_activity_version_id => p_rec.activity_version_id

Line 642: ota_tpm_bus1.chk_unique(

638: -- ELSIF l_person_id = 0 THEN
639: ELSE
640:
641: hr_utility.set_location(' Step:'|| l_proc, 90);
642: ota_tpm_bus1.chk_unique(
643: p_training_plan_member_id => p_rec.training_plan_member_id
644: ,p_object_version_number => p_rec.object_version_number
645: ,p_activity_definition_id => p_rec.activity_definition_id
646: ,p_activity_version_id => p_rec.activity_version_id

Line 675: ota_tpm_bus1.chk_delete(

671: -- Call all supporting business operations
672: --
673: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_member_id);
674: hr_utility.set_location(' tpm is ', ota_tpm_shd.g_old_rec.training_plan_id);
675: ota_tpm_bus1.chk_delete(
676: p_training_plan_member_id => ota_tpm_shd.g_old_rec.training_plan_member_id
677: ,p_training_plan_id => ota_tpm_shd.g_old_rec.training_plan_id );
678: --
679: hr_utility.set_location(' Leaving:'||l_proc, 10);