DBA Data[Home] [Help]

APPS.PAY_PAY_UPD dependencies on PAY_ALL_PAYROLLS_F

Line 81: (p_base_table_name => 'pay_all_payrolls_f'

77: -- version number.
78: --
79: p_rec.object_version_number :=
80: dt_api.get_object_version_number
81: (p_base_table_name => 'pay_all_payrolls_f'
82: ,p_base_key_column => 'payroll_id'
83: ,p_base_key_value => p_rec.payroll_id
84: );
85: --

Line 88: -- Update the pay_all_payrolls_f Row

84: );
85: --
86: pay_pay_shd.g_api_dml := true; -- Set the api dml status
87: --
88: -- Update the pay_all_payrolls_f Row
89: --
90: update pay_all_payrolls_f
91: set
92: payroll_id = p_rec.payroll_id

Line 90: update pay_all_payrolls_f

86: pay_pay_shd.g_api_dml := true; -- Set the api dml status
87: --
88: -- Update the pay_all_payrolls_f Row
89: --
90: update pay_all_payrolls_f
91: set
92: payroll_id = p_rec.payroll_id
93: ,default_payment_method_id = p_rec.default_payment_method_id
94: ,business_group_id = p_rec.business_group_id

Line 422: ,p_source_table_name => 'PAY_ALL_PAYROLLS_F'

418: --
419: If (p_rec.comments is not null and p_rec.comment_id is null) then
420: --
421: hr_comm_api.ins(p_comment_id => p_rec.comment_id
422: ,p_source_table_name => 'PAY_ALL_PAYROLLS_F'
423: ,p_comment_text => p_rec.comments
424: );
425: -- Update the comments if they have changed
426: ElsIf (p_rec.comment_id is not null and p_rec.comments <>

Line 431: ,p_source_table_name => 'PAY_ALL_PAYROLLS_F'

427: pay_pay_shd.g_old_rec.comments) then
428: --
429:
430: hr_comm_api.upd(p_comment_id => p_rec.comment_id
431: ,p_source_table_name => 'PAY_ALL_PAYROLLS_F'
432: ,p_comment_text => p_rec.comments
433: );
434:
435: /*

Line 448: ,p_source_table_name => 'PAY_ALL_PAYROLLS_F'

444: -- so, whenever the comment_text is changed then we call this ins proc
445: -- to generate a new comment_id.
446: -- 5144323 / 5609830 starts
447: hr_comm_api.ins(p_comment_id => p_rec.comment_id
448: ,p_source_table_name => 'PAY_ALL_PAYROLLS_F'
449: ,p_comment_text => p_rec.comments
450: );
451: --5144323 / 5609830 ends
452: */ --

Line 728: (p_module_name => 'PAY_ALL_PAYROLLS_F'

724: --
725: when hr_api.cannot_find_prog_unit then
726: --
727: hr_api.cannot_find_prog_unit_error
728: (p_module_name => 'PAY_ALL_PAYROLLS_F'
729: ,p_hook_type => 'AU');
730: --
731: end;
732: --