DBA Data[Home] [Help]

APPS.OTA_TRNG_PLAN_COMP_SS dependencies on OTA_TPS_API

Line 139: ota_tps_api.update_training_plan

135: FETCH csr_tp_update into l_name,l_object_version_number,l_time_period_id,l_budget_currency;
136: IF csr_tp_update%FOUND then
137: CLOSE csr_tp_update;
138: --update TP
139: ota_tps_api.update_training_plan
140: (p_effective_date => sysdate
141: ,p_training_plan_id => rec1.training_plan_id
142: ,p_object_version_NUMBER => l_object_version_number
143: ,p_plan_status_type_id => 'COMPLETED'

Line 562: ota_tps_api.update_training_plan

558: FETCH csr_tp_update into l_name,l_object_version_number,l_time_period_id,l_budget_currency;
559: IF csr_tp_update%FOUND then
560: CLOSE csr_tp_update;
561: --update TP
562: ota_tps_api.update_training_plan
563: (p_effective_date => sysdate
564: ,p_training_plan_id => rec1.training_plan_id
565: ,p_object_version_NUMBER => l_object_version_number
566: -- Modified to use OTA_COMPLETED

Line 647: ota_tps_api.update_training_plan

643: OPEN csr_tp_update(rec1.training_plan_id);
644: FETCH csr_tp_update into l_name,l_object_version_number,l_time_period_id,l_budget_currency;
645: IF csr_tp_update%FOUND then
646: CLOSE csr_tp_update;
647: ota_tps_api.update_training_plan
648: (p_effective_date => sysdate
649: ,p_training_plan_id => rec1.training_plan_id
650: ,p_object_version_number => l_object_version_number
651: ,p_plan_status_type_id => l_plan_status_type_id

Line 729: ota_tps_api.update_training_plan

725: OPEN csr_tp_update(rec1.training_plan_id);
726: FETCH csr_tp_update into l_name,l_object_version_number,l_time_period_id,l_budget_currency;
727: IF csr_tp_update%FOUND then
728: CLOSE csr_tp_update;
729: ota_tps_api.update_training_plan
730: (p_effective_date => sysdate
731: ,p_training_plan_id => rec1.training_plan_id
732: ,p_object_version_number => l_object_version_number
733: ,p_plan_status_type_id => l_plan_status_type_id