32: -- Internal Development Use Only.
33: --
34: procedure chk_external_account_id
35: (p_personal_payment_method_id in
36: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
37: ,p_org_payment_method_id in
38: pay_personal_payment_methods_f.org_payment_method_id%TYPE
39: ,p_external_account_id in number
40: ,p_effective_date in date
34: procedure chk_external_account_id
35: (p_personal_payment_method_id in
36: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
37: ,p_org_payment_method_id in
38: pay_personal_payment_methods_f.org_payment_method_id%TYPE
39: ,p_external_account_id in number
40: ,p_effective_date in date
41: ,p_object_version_number in
42: pay_personal_payment_methods_f.object_version_number%TYPE
38: pay_personal_payment_methods_f.org_payment_method_id%TYPE
39: ,p_external_account_id in number
40: ,p_effective_date in date
41: ,p_object_version_number in
42: pay_personal_payment_methods_f.object_version_number%TYPE
43: );
44: -- ----------------------------------------------------------------------------
45: -- |----------------------< check_non_updateable_args >-----------------------|
46: -- ----------------------------------------------------------------------------
111: -- Internal Development Use Only.
112: --
113: procedure chk_priority
114: (p_priority in
115: pay_personal_payment_methods_f.priority%TYPE
116: ,p_personal_payment_method_id in
117: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
118: ,p_org_payment_method_id in
119: pay_personal_payment_methods_f.org_payment_method_id%TYPE
113: procedure chk_priority
114: (p_priority in
115: pay_personal_payment_methods_f.priority%TYPE
116: ,p_personal_payment_method_id in
117: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
118: ,p_org_payment_method_id in
119: pay_personal_payment_methods_f.org_payment_method_id%TYPE
120: ,p_assignment_id in
121: pay_personal_payment_methods_f.assignment_id%TYPE
115: pay_personal_payment_methods_f.priority%TYPE
116: ,p_personal_payment_method_id in
117: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
118: ,p_org_payment_method_id in
119: pay_personal_payment_methods_f.org_payment_method_id%TYPE
120: ,p_assignment_id in
121: pay_personal_payment_methods_f.assignment_id%TYPE
122: ,p_run_type_id in
123: pay_personal_payment_methods_f.run_type_id%TYPE
117: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
118: ,p_org_payment_method_id in
119: pay_personal_payment_methods_f.org_payment_method_id%TYPE
120: ,p_assignment_id in
121: pay_personal_payment_methods_f.assignment_id%TYPE
122: ,p_run_type_id in
123: pay_personal_payment_methods_f.run_type_id%TYPE
124: ,p_effective_date in date
125: ,p_object_version_number in
119: pay_personal_payment_methods_f.org_payment_method_id%TYPE
120: ,p_assignment_id in
121: pay_personal_payment_methods_f.assignment_id%TYPE
122: ,p_run_type_id in
123: pay_personal_payment_methods_f.run_type_id%TYPE
124: ,p_effective_date in date
125: ,p_object_version_number in
126: pay_personal_payment_methods_f.object_version_number%TYPE
127: ,p_validation_start_date in date
122: ,p_run_type_id in
123: pay_personal_payment_methods_f.run_type_id%TYPE
124: ,p_effective_date in date
125: ,p_object_version_number in
126: pay_personal_payment_methods_f.object_version_number%TYPE
127: ,p_validation_start_date in date
128: ,p_validation_end_date in date
129: );
130: -- ---------------------------------------------------------------------------
170: -- Internal Development Use Only.
171: --
172: procedure chk_amount_percent
173: (p_amount in
174: pay_personal_payment_methods_f.amount%TYPE
175: ,p_percentage in
176: pay_personal_payment_methods_f.percentage%TYPE
177: ,p_personal_payment_method_id in
178: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
172: procedure chk_amount_percent
173: (p_amount in
174: pay_personal_payment_methods_f.amount%TYPE
175: ,p_percentage in
176: pay_personal_payment_methods_f.percentage%TYPE
177: ,p_personal_payment_method_id in
178: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
179: ,p_org_payment_method_id in
180: pay_personal_payment_methods_f.org_payment_method_id%TYPE
174: pay_personal_payment_methods_f.amount%TYPE
175: ,p_percentage in
176: pay_personal_payment_methods_f.percentage%TYPE
177: ,p_personal_payment_method_id in
178: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
179: ,p_org_payment_method_id in
180: pay_personal_payment_methods_f.org_payment_method_id%TYPE
181: ,p_effective_date in date
182: ,p_object_version_number in
176: pay_personal_payment_methods_f.percentage%TYPE
177: ,p_personal_payment_method_id in
178: pay_personal_payment_methods_f.personal_payment_method_id%TYPE
179: ,p_org_payment_method_id in
180: pay_personal_payment_methods_f.org_payment_method_id%TYPE
181: ,p_effective_date in date
182: ,p_object_version_number in
183: pay_personal_payment_methods_f.object_version_number%TYPE
184: );
179: ,p_org_payment_method_id in
180: pay_personal_payment_methods_f.org_payment_method_id%TYPE
181: ,p_effective_date in date
182: ,p_object_version_number in
183: pay_personal_payment_methods_f.object_version_number%TYPE
184: );
185: -- ---------------------------------------------------------------------------
186: -- |-------------------< chk_org_payment_method_id >-----------------------|
187: -- ---------------------------------------------------------------------------
282: --
283: -- Description:
284: -- Sets the value of the proposed new effective_end_date
285: -- depending on the existence of future rows in
286: -- pay_personal_payment_methods_f which have the same priority
287: --
288: -- Pre-conditions:
289: -- None
290: --
291: -- In Arguments:
292: --
293: -- Post Success:
294: --
295: -- If any rows exist on pay_personal_payment_methods_f in the future
296: -- that have the same priority, for the same assignment, as p_priority then
297: --
298: -- a) If the earliest future effective start date -1 is less than
299: -- p_validation_end_date then
303: -- b) The earliest future effective start date -1 is not less than
304: -- p_validation_end_date then
305: -- p_validation_end_date remains the same
306: --
307: -- If no future rows exist on pay_personal_payment_methods_f in the future
308: -- that have the same priority as p_priority then
309: -- p_validation_end_date remains the same
310: --
311: -- Post Failure: