DBA Data[Home] [Help]

APPS.PAY_ETP_UPD_ND dependencies on PAY_ELEMENT_TYPES_F

Line 78: (p_base_table_name => 'pay_element_types_f'

74: -- version number.
75: --
76: p_rec.object_version_number :=
77: dt_api.get_object_version_number
78: (p_base_table_name => 'pay_element_types_f'
79: ,p_base_key_column => 'element_type_id'
80: ,p_base_key_value => p_rec.element_type_id
81: );
82: --

Line 85: -- Update the pay_element_types_f Row

81: );
82: --
83: pay_etp_shd_nd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pay_element_types_f Row
86: --
87: update pay_element_types_f
88: set
89: element_type_id = p_rec.element_type_id

Line 87: update pay_element_types_f

83: pay_etp_shd_nd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pay_element_types_f Row
86: --
87: update pay_element_types_f
88: set
89: element_type_id = p_rec.element_type_id
90: ,business_group_id = p_rec.business_group_id
91: ,legislation_code = p_rec.legislation_code

Line 407: ,p_source_table_name => 'PAY_ELEMENT_TYPES_F'

403: -- Insert the comment text if comments exist
404: --
405: If (p_rec.comments is not null and p_rec.comment_id is null) then
406: hr_comm_api.ins(p_comment_id => p_rec.comment_id
407: ,p_source_table_name => 'PAY_ELEMENT_TYPES_F'
408: ,p_comment_text => p_rec.comments
409: );
410: -- Update the comments if they have changed
411: ElsIf (p_rec.comment_id is not null and p_rec.comments <>

Line 414: ,p_source_table_name => 'PAY_ELEMENT_TYPES_F'

410: -- Update the comments if they have changed
411: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
412: pay_etp_shd_nd.g_old_rec.comments) then
413: hr_comm_api.upd(p_comment_id => p_rec.comment_id
414: ,p_source_table_name => 'PAY_ELEMENT_TYPES_F'
415: ,p_comment_text => p_rec.comments
416: );
417: End If;
418: --

Line 862: (p_module_name => 'PAY_ELEMENT_TYPES_F'

858: --
859: when hr_api.cannot_find_prog_unit then
860: --
861: hr_api.cannot_find_prog_unit_error
862: (p_module_name => 'PAY_ELEMENT_TYPES_F'
863: ,p_hook_type => 'AU');
864: --
865: end;
866: --