DBA Data[Home] [Help]

APPS.PER_BUDGET_VALUES_PKG dependencies on PER_BUDGETS_PKG

Line 501: IF per_budgets_pkg.chk_OTA_budget_type(NULL,l_budget_version_id,NULL) THEN

497: -- Is the parent per_budgets rec 'OTA_BUDGET'
498: -- If so, does a per_budget_values rec already exist for the budget_element_id
499: -- If so, check many_budget_values flag to see if another per_budget_values record
500: -- should be created otherwise raise error.
501: IF per_budgets_pkg.chk_OTA_budget_type(NULL,l_budget_version_id,NULL) THEN
502: OPEN C3;
503: FETCH C3 into l_result;
504: IF C3%FOUND THEN
505: IF get_many_budget_values(x_business_group_id, l_budget_version_id) = FALSE THEN

Line 1169: IF per_budgets_pkg.chk_OTA_budget_type(NULL,l_budget_version_id,NULL) THEN

1165: -- Is the parent per_budgets rec 'OTA_BUDGET'
1166: -- If so, does a per_budget_values rec already exist for the budget_element_id
1167: -- If so, check many_budget_values flag to see if another per_budget_values record
1168: -- should be created otherwise raise error.
1169: IF per_budgets_pkg.chk_OTA_budget_type(NULL,l_budget_version_id,NULL) THEN
1170: OPEN C3;
1171: FETCH C3 into l_result;
1172: IF C3%FOUND THEN
1173: null;

Line 1360: IF per_budgets_pkg.chk_OTA_Budget_Type(NULL, l_budget_version_id, NULL) = TRUE THEN

1356: --
1357: -- As this is an OTA_BUDGET record, determine how many value
1358: -- records exist for a parent budget element
1359: -- If this is the last, then prepare to delete parent budget element.
1360: IF per_budgets_pkg.chk_OTA_Budget_Type(NULL, l_budget_version_id, NULL) = TRUE THEN
1361: BEGIN
1362: SELECT count(rowid)
1363: INTO l_count
1364: FROM per_budget_values