74: -- version number.
75: --
76: p_rec.object_version_number :=
77: dt_api.get_object_version_number
78: (p_base_table_name => 'pay_org_payment_methods_f'
79: ,p_base_key_column => 'org_payment_method_id'
80: ,p_base_key_value => p_rec.org_payment_method_id
81: );
82: --
81: );
82: --
83: pay_opm_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pay_org_payment_methods_f Row
86: --
87: update pay_org_payment_methods_f
88: set
89: org_payment_method_id = p_rec.org_payment_method_id
83: pay_opm_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pay_org_payment_methods_f Row
86: --
87: update pay_org_payment_methods_f
88: set
89: org_payment_method_id = p_rec.org_payment_method_id
90: ,business_group_id = p_rec.business_group_id
91: ,external_account_id = p_rec.external_account_id
372: -- Insert the comment text if comments exist
373: --
374: If (p_rec.comments is not null and p_rec.comment_id is null) then
375: hr_comm_api.ins(p_comment_id => p_rec.comment_id
376: ,p_source_table_name => 'PAY_ORG_PAYMENT_METHODS_F'
377: ,p_comment_text => p_rec.comments
378: );
379: -- Update the comments if they have changed
380: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
379: -- Update the comments if they have changed
380: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
381: pay_opm_shd.g_old_rec.comments) then
382: hr_comm_api.upd(p_comment_id => p_rec.comment_id
383: ,p_source_table_name => 'PAY_ORG_PAYMENT_METHODS_F'
384: ,p_comment_text => p_rec.comments
385: );
386: End If;
387: --
683: --
684: when hr_api.cannot_find_prog_unit then
685: --
686: hr_api.cannot_find_prog_unit_error
687: (p_module_name => 'PAY_ORG_PAYMENT_METHODS_F'
688: ,p_hook_type => 'AU');
689: --
690: end;
691: --