DBA Data[Home] [Help]

APPS.PER_BUDGET_VERSION_RULES_PKG dependencies on PER_BUDGETS_PKG

Line 38: IF per_budgets_pkg.chk_OTA_Budget_Type(l_budget_id, NULL, NULL) = FALSE THEN

34: OPEN C_Elements;
35: -- Cascade delete the appropriate child budget_elements recs if
36: -- parent per_budgets budget_type_code is 'HR_BUDGET';
37: -- (use budget_id in chk_ota_budget_type)
38: IF per_budgets_pkg.chk_OTA_Budget_Type(l_budget_id, NULL, NULL) = FALSE THEN
39: LOOP
40: FETCH C_Elements into l_ele_rowid;
41: EXIT when (C_Elements%NOTFOUND);
42: PER_BUDGET_ELEMENTS_PKG.Delete_Row(X_Rowid => l_ele_rowid);

Line 692: IF per_budgets_pkg.Chk_OTA_Budget_Type(X_Budget_id,NULL,NULL) THEN

688: p_argument_value => X_Budget_Id);
689:
690: -- If the parent record is OTA_BUDGET type, and no budget version exists
691: -- for the budget_id then continue, else raise error.
692: IF per_budgets_pkg.Chk_OTA_Budget_Type(X_Budget_id,NULL,NULL) THEN
693: IF vers_exists(X_Budget_id,NULL) THEN
694: hr_utility.set_message(800,'HR_52873_OTA_BUD_EXISTS');
695: hr_utility.raise_error;
696: ELSE

Line 1095: IF per_budgets_pkg.Chk_OTA_Budget_Type(X_Budget_id,NULL,NULL) THEN

1091: p_argument_value => X_Budget_Id);
1092:
1093: -- If the parent record is OTA_BUDGET type, and no budget version exists
1094: -- for the budget_id then continue, else raise error.
1095: IF per_budgets_pkg.Chk_OTA_Budget_Type(X_Budget_id,NULL,NULL) THEN
1096: IF vers_exists(X_Budget_id,X_Rowid) THEN
1097: hr_utility.set_message(800,'PER_52873_OTA_BUD_EXISTS');
1098: hr_utility.raise_error;
1099: ELSE