APPS.OTA_TMT_API dependencies on PER_BUDGETS

Line 541: from PER_BUDGETS pb

537: l_exists varchar2(1);
538: --
539: cursor csr_get_budget_rowid is
540: select pb.rowid row_id
541: from PER_BUDGETS pb
542: where ota_tmt_shd.g_old_rec.tp_measurement_code = pb.unit
543: and ota_tmt_shd.g_old_rec.business_group_id = pb.business_group_id
544: and ota_tmt_shd.g_old_rec.tp_measurement_type_id = p_tp_measurement_type_id
545: and pb.budget_type_code = 'OTA_BUDGET';

Line 549: from PER_BUDGETS pb

545: and pb.budget_type_code = 'OTA_BUDGET';
546: --
547: cursor csr_get_budget_version_rowid is
548: select pbv.rowid row_id
549: from PER_BUDGETS pb
550: ,PER_BUDGET_VERSIONS pbv
551: where ota_tmt_shd.g_old_rec.tp_measurement_code = pb.unit
552: and ota_tmt_shd.g_old_rec.business_group_id = pb.business_group_id
553: and ota_tmt_shd.g_old_rec.tp_measurement_type_id = p_tp_measurement_type_id

Line 598: -- per_budget_elements records, then the per_budgets rcords

594: -- The business rules only allow deletion of the measure if no
595: -- PER_BUDGET_VALUES records exist For the business group.
596: -- An exception would have been raised by the chk_ procedures
597: -- if this was the case, so we can proceed and delete the
598: -- per_budget_elements records, then the per_budgets rcords
599: --
600: -- Delete the per_budget_version records (if any exist)
601: --
602: FOR l_loop IN csr_get_budget_version_rowid LOOP

Line 607: -- Delete the per_budgets records (if any exist)

603: hr_utility.set_location(' Step:'|| l_proc, 70);
604: PER_BUDGET_VERSION_RULES_PKG.Delete_Row(X_Rowid => l_loop.row_id);
605: END LOOP;
606: --
607: -- Delete the per_budgets records (if any exist)
608: --
609: FOR l_loop IN csr_get_budget_rowid LOOP
610: hr_utility.set_location(' Step:'|| l_proc, 80);
611: per_budgets_pkg.delete_row(X_Rowid => l_loop.row_id);

Line 611: per_budgets_pkg.delete_row(X_Rowid => l_loop.row_id);

607: -- Delete the per_budgets records (if any exist)
608: --
609: FOR l_loop IN csr_get_budget_rowid LOOP
610: hr_utility.set_location(' Step:'|| l_proc, 80);
611: per_budgets_pkg.delete_row(X_Rowid => l_loop.row_id);
612: END LOOP;
613: --
614: -- Call After Process User Hook
615: --