DBA Data[Home] [Help]

APPS.BEN_ASG_BUDGET_VALUES dependencies on PER_ABV_PKG

Line 133: per_abv_pkg.get_parent_max_end_date(p_assignment_id => p_assignment_id

129:
130: -- Date track coding,get the maximum effective end date from the assignment
131: -- table (parent record) to ensure that budget values can not go pass
132: -- this date.
133: per_abv_pkg.get_parent_max_end_date(p_assignment_id => p_assignment_id
134: ,p_end_date => l_parent_effective_end_date);
135: -- if the session date is greater than the parent assignment end date then raise an error
136: -- as a record can not be inserted after the end of the parent assignment.
137: if p_effective_date > l_parent_effective_end_date then

Line 154: per_abv_pkg.check_for_duplicate_record(p_assignment_id => p_assignment_id

150: close c2;
151:
152: -- Date track coding, check for an existing record,using the parent end date to determine
153: -- if a record exists.
154: per_abv_pkg.check_for_duplicate_record(p_assignment_id => p_assignment_id
155: ,p_unit => p_unit
156: ,p_start_date => p_effective_date
157: ,p_end_date => l_parent_effective_end_date);
158: per_abv_pkg.pre_commit_checks

Line 158: per_abv_pkg.pre_commit_checks

154: per_abv_pkg.check_for_duplicate_record(p_assignment_id => p_assignment_id
155: ,p_unit => p_unit
156: ,p_start_date => p_effective_date
157: ,p_end_date => l_parent_effective_end_date);
158: per_abv_pkg.pre_commit_checks
159: (p_assignment_id => p_assignment_id
160: ,p_unit => p_unit
161: ,p_rowid => p_rowid
162: ,p_unique_id => l_assignment_budget_value_id);