APPS.PAY_PGA_SHD dependencies on PAY_PAYMENT_GL_ACCOUNTS_F

Line 59: from pay_payment_gl_accounts_f

55: ,gl_error_ac_id
56: ,external_account_id
57: ,org_payment_method_id
58: ,object_version_number
59: from pay_payment_gl_accounts_f
60: where pay_gl_account_id = p_pay_gl_account_id
61: and p_effective_date
62: between effective_start_date and effective_end_date;
63: --

Line 135: ,p_base_table_name => 'pay_payment_gl_accounts_f'

131: -- Call the corresponding datetrack api
132: --
133: dt_api.find_dt_upd_modes
134: (p_effective_date => p_effective_date
135: ,p_base_table_name => 'pay_payment_gl_accounts_f'
136: ,p_base_key_column => 'pay_gl_account_id'
137: ,p_base_key_value => p_base_key_value
138: ,p_correction => p_correction
139: ,p_update => p_update

Line 169: ,p_base_table_name => 'pay_payment_gl_accounts_f'

165: -- Call the corresponding datetrack api
166: --
167: dt_api.find_dt_del_modes
168: (p_effective_date => p_effective_date
169: ,p_base_table_name => 'pay_payment_gl_accounts_f'
170: ,p_base_key_column => 'pay_gl_account_id'
171: ,p_base_key_value => p_base_key_value
172: ,p_zap => p_zap
173: ,p_delete => p_delete

Line 204: (p_base_table_name => 'pay_payment_gl_accounts_f'

200: -- version number.
201: --
202: l_object_version_number :=
203: dt_api.get_object_version_number
204: (p_base_table_name => 'pay_payment_gl_accounts_f'
205: ,p_base_key_column => 'pay_gl_account_id'
206: ,p_base_key_value => p_base_key_value
207: );
208: --

Line 215: update pay_payment_gl_accounts_f t

211: --
212: -- Update the specified datetrack row setting the effective
213: -- end date to the specified new effective end date.
214: --
215: update pay_payment_gl_accounts_f t
216: set t.effective_end_date = p_new_effective_end_date
217: , t.object_version_number = l_object_version_number
218: where t.pay_gl_account_id = p_base_key_value
219: and p_effective_date

Line 261: from pay_payment_gl_accounts_f

257: ,gl_error_ac_id
258: ,external_account_id
259: ,org_payment_method_id
260: ,object_version_number
261: from pay_payment_gl_accounts_f
262: where pay_gl_account_id = p_pay_gl_account_id
263: and p_effective_date
264: between effective_start_date and effective_end_date
265: for update nowait;

Line 326: ,p_base_table_name => 'pay_payment_gl_accounts_f'

322:
323: dt_api.validate_dt_mode
324: (p_effective_date => p_effective_date
325: ,p_datetrack_mode => p_datetrack_mode
326: ,p_base_table_name => 'pay_payment_gl_accounts_f'
327: ,p_base_key_column => 'pay_gl_account_id'
328: ,p_base_key_value => p_pay_gl_account_id
329: ,p_parent_table_name1 => 'pay_org_payment_methods_f'
330: ,p_parent_key_column1 => 'org_payment_method_id'

Line 342: ,p_base_table_name => 'pay_payment_gl_accounts_f'

338:
339: dt_api.validate_dt_mode
340: (p_effective_date => p_effective_date
341: ,p_datetrack_mode => p_datetrack_mode
342: ,p_base_table_name => 'pay_payment_gl_accounts_f'
343: ,p_base_key_column => 'pay_gl_account_id'
344: ,p_base_key_value => p_pay_gl_account_id
345: ,p_enforce_foreign_locking => true
346: ,p_validation_start_date => l_validation_start_date

Line 379: fnd_message.set_token('TABLE_NAME', 'pay_payment_gl_accounts_f');

375: -- The object is locked therefore we need to supply a meaningful
376: -- error message.
377: --
378: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
379: fnd_message.set_token('TABLE_NAME', 'pay_payment_gl_accounts_f');
380: fnd_message.raise_error;
381: End lck;
382: --
383: -- ----------------------------------------------------------------------------