DBA Data[Home] [Help]

APPS.PAY_PPM_BUS dependencies on PAY_PERSONAL_PAYMENT_METHODS_F

Line 36: pay_personal_payment_methods_f.personal_payment_method_id%TYPE

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

Line 38: pay_personal_payment_methods_f.org_payment_method_id%TYPE

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

Line 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: -- ----------------------------------------------------------------------------

Line 115: pay_personal_payment_methods_f.priority%TYPE

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

Line 117: pay_personal_payment_methods_f.personal_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

Line 119: pay_personal_payment_methods_f.org_payment_method_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

Line 121: pay_personal_payment_methods_f.assignment_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

Line 123: pay_personal_payment_methods_f.run_type_id%TYPE

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

Line 126: pay_personal_payment_methods_f.object_version_number%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
128: ,p_validation_end_date in date
129: );
130: -- ---------------------------------------------------------------------------

Line 174: pay_personal_payment_methods_f.amount%TYPE

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

Line 176: pay_personal_payment_methods_f.percentage%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

Line 178: pay_personal_payment_methods_f.personal_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

Line 180: pay_personal_payment_methods_f.org_payment_method_id%TYPE

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: );

Line 183: pay_personal_payment_methods_f.object_version_number%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: );
185: -- ---------------------------------------------------------------------------
186: -- |-------------------< chk_org_payment_method_id >-----------------------|
187: -- ---------------------------------------------------------------------------

Line 286: -- pay_personal_payment_methods_f which have the same priority

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: --

Line 295: -- If any rows exist on pay_personal_payment_methods_f in the future

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

Line 307: -- If no future rows exist on pay_personal_payment_methods_f in the future

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: