DBA Data[Home] [Help]

APPS.BEN_PEN_UPD dependencies on BEN_PRTT_ENRT_RSLT_F

Line 77: (p_base_table_name => 'ben_prtt_enrt_rslt_f',

73: -- version number.
74: --
75: p_rec.object_version_number :=
76: dt_api.get_object_version_number
77: (p_base_table_name => 'ben_prtt_enrt_rslt_f',
78: p_base_key_column => 'prtt_enrt_rslt_id',
79: p_base_key_value => p_rec.prtt_enrt_rslt_id);
80: --
81: ben_pen_shd.g_api_dml := true; -- Set the api dml status

Line 83: -- Update the ben_prtt_enrt_rslt_f Row

79: p_base_key_value => p_rec.prtt_enrt_rslt_id);
80: --
81: ben_pen_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_prtt_enrt_rslt_f Row
84: --
85: update ben_prtt_enrt_rslt_f
86: set
87: prtt_enrt_rslt_id = p_rec.prtt_enrt_rslt_id,

Line 85: update ben_prtt_enrt_rslt_f

81: ben_pen_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_prtt_enrt_rslt_f Row
84: --
85: update ben_prtt_enrt_rslt_f
86: set
87: prtt_enrt_rslt_id = p_rec.prtt_enrt_rslt_id,
88: business_group_id = p_rec.business_group_id,
89: oipl_id = p_rec.oipl_id,

Line 408: from ben_prtt_enrt_rslt_f

404: l_eed date;
405: --
406: cursor csr_rowid is
407: select rowid, effective_start_date, effective_end_date
408: from ben_prtt_enrt_rslt_f
409: where prtt_enrt_rslt_id = p_rec.prtt_enrt_rslt_id
410: and p_effective_date between
411: effective_start_date and effective_end_date;
412:

Line 415: from ben_prtt_enrt_rslt_f

411: effective_start_date and effective_end_date;
412:
413: cursor csr_rowid_u is
414: select rowid
415: from ben_prtt_enrt_rslt_f
416: where prtt_enrt_rslt_id = p_rec.prtt_enrt_rslt_id
417: and p_effective_date -1 between
418: effective_start_date and effective_end_date;
419: --

Line 687: (p_module_name => 'ben_prtt_enrt_rslt_f'

683:
684: exception
685: when hr_api.cannot_find_prog_unit then
686: hr_api.cannot_find_prog_unit_error
687: (p_module_name => 'ben_prtt_enrt_rslt_f'
688: ,p_hook_type => 'AU');
689: end;
690: --
691: -- End of API User Hook for post_update.