DBA Data[Home] [Help]

APPS.PAY_PPR_UPD dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 78: (p_base_table_name => 'pay_status_processing_rules_f'

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

Line 85: -- Update the pay_status_processing_rules_f Row

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

Line 87: update pay_status_processing_rules_f

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

Line 329: ,p_source_table_name => 'PAY_STATUS_PROCESSING_RULES_F'

325: -- Insert the comment text if comments exist
326: --
327: If (p_rec.comments is not null and p_rec.comment_id is null) then
328: hr_comm_api.ins(p_comment_id => p_rec.comment_id
329: ,p_source_table_name => 'PAY_STATUS_PROCESSING_RULES_F'
330: ,p_comment_text => p_rec.comments
331: );
332: -- Update the comments if they have changed
333: ElsIf (p_rec.comment_id is not null and p_rec.comments <>

Line 336: ,p_source_table_name => 'PAY_STATUS_PROCESSING_RULES_F'

332: -- Update the comments if they have changed
333: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
334: pay_ppr_shd.g_old_rec.comments) then
335: hr_comm_api.upd(p_comment_id => p_rec.comment_id
336: ,p_source_table_name => 'PAY_STATUS_PROCESSING_RULES_F'
337: ,p_comment_text => p_rec.comments
338: );
339: End If;
340: --

Line 436: (p_module_name => 'PAY_STATUS_PROCESSING_RULES_F'

432: --
433: when hr_api.cannot_find_prog_unit then
434: --
435: hr_api.cannot_find_prog_unit_error
436: (p_module_name => 'PAY_STATUS_PROCESSING_RULES_F'
437: ,p_hook_type => 'AU');
438: --
439: end;
440: --