eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BENUTILS dependencies on HR_API

Line 703: if (hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y') or (nvl(l_rec.mode_cd,hr_api.g_varchar2) = 'W')

699: hr_utility.set_location('Entering:'||l_proc, 5);
700: ben_env_object.get(l_rec);
701: -- Perf changes
702: -- bug 8431552: Skip the security profile check for CWB mode
703: if (hr_security.view_all = 'Y' and hr_general.get_xbg_profile = 'Y') or (nvl(l_rec.mode_cd,hr_api.g_varchar2) = 'W')
704: then
705: open c_all_assignment;
706: --
707: fetch c_all_assignment into l_assignment_id;

Line 3261: if p_new_column = hr_api.g_eot then

3257: -- Bug 1167917 Do not trigger date oabany's for null nor end of time.
3258: -- eot is a date that should work like null.
3259: -- Bug#2001857-null value must be treated differently as the condition above checks
3260: -- and both the values are null then false is returnedi-null condition masked
3261: if p_new_column = hr_api.g_eot then
3262: -- or p_new_column is null then
3263: hr_utility.set_location('FALSE2',10);
3264: return FALSE;
3265: else

Line 3271: p_new_column = hr_api.g_eot)

3267: return TRUE;
3268: end if;
3269: elsif ((p_new_value = 'NULL')
3270: AND (p_new_column IS NULL or
3271: p_new_column = hr_api.g_eot)
3272: )
3273: then
3274: -- Bug 1167017, treat eot as null
3275: hr_utility.set_location('TRUE4',10);

Line 3279: p_new_column <> hr_api.g_eot)

3275: hr_utility.set_location('TRUE4',10);
3276: return TRUE;
3277: elsif ((p_new_value = 'NULL')
3278: AND (p_new_column IS NOT NULL) and
3279: p_new_column <> hr_api.g_eot)
3280: then
3281: hr_utility.set_location('FALSE5',10);
3282: return FALSE;
3283: elsif p_new_value = 'ENDTM' and p_new_column = hr_api.g_eot then

Line 3283: elsif p_new_value = 'ENDTM' and p_new_column = hr_api.g_eot then

3279: p_new_column <> hr_api.g_eot)
3280: then
3281: hr_utility.set_location('FALSE5',10);
3282: return FALSE;
3283: elsif p_new_value = 'ENDTM' and p_new_column = hr_api.g_eot then
3284: hr_utility.set_location('TRUE5',10);
3285: return true;
3286: elsif ((p_new_column IS NOT NULL)
3287: AND (to_char(p_new_column) = p_new_value)

Line 3946: if p_date = hr_api.g_eot then

3942: begin
3943: --
3944: hr_utility.set_location ('Entering '||l_package,10);
3945: --
3946: if p_date = hr_api.g_eot then
3947: --
3948: l_date := null;
3949: --
3950: else

Line 4801: --and prv.rt_end_dt = hr_api.g_eot;

4797: and prv.per_in_ler_id = p_per_in_ler_id
4798: and prv.prtt_rt_val_stat_cd is null -- Added for Bug 6048854
4799: and prv.rt_strt_dt <= prv.rt_end_dt;
4800: --Commented for Bug 6048854
4801: --and prv.rt_end_dt = hr_api.g_eot;
4802: --
4803: --
4804:
4805: /* Commented for Bug 6048854

Line 4813: and prv.rt_end_dt <> hr_api.g_eot;

4809: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4810: and prv.per_in_ler_id = p_per_in_ler_id
4811: Bug 5376185 : Pick the latest non-recurring rate
4812: and prv.rt_strt_dt = prv.rt_end_dt
4813: and prv.rt_end_dt <> hr_api.g_eot;
4814: */
4815: --
4816: l_rt_val number := null;
4817: --

Line 4858: --and prv.rt_end_dt = hr_api.g_eot;

4854: and prv.per_in_ler_id = p_per_in_ler_id
4855: and prv.prtt_rt_val_stat_cd is null -- Added for Bug 6048854
4856: and prv.rt_strt_dt <= prv.rt_end_dt;
4857: --Commented for Bug 6048854
4858: --and prv.rt_end_dt = hr_api.g_eot;
4859: --
4860: --
4861: /* Commented for Bug 6048854
4862: cursor c_prv2 is

Line 4869: and prv.rt_end_dt <> hr_api.g_eot;

4865: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4866: and prv.per_in_ler_id = p_per_in_ler_id
4867: Bug 5376185 : Pick the latest non-recurring rate
4868: and prv.rt_strt_dt = prv.rt_end_dt
4869: and prv.rt_end_dt <> hr_api.g_eot;
4870: */
4871: --
4872: l_rt_val number := null;
4873: --

Line 4908: and prv.rt_end_dt = hr_api.g_eot;

4904: select to_char(nvl(prv.ann_rt_val,0))||'^'|| to_char(nvl(prv.cmcd_rt_val,0))||'^'||to_char(nvl(prv.rt_val,0))
4905: from ben_prtt_rt_val prv
4906: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4907: and prv.per_in_ler_id = p_per_in_ler_id
4908: and prv.rt_end_dt = hr_api.g_eot;
4909: --
4910: l_rt_val varchar2(100) := null;
4911: --
4912: begin

Line 4941: --and prv.rt_end_dt = hr_api.g_eot;

4937: and prv.per_in_ler_id = p_per_in_ler_id
4938: and prv.prtt_rt_val_stat_cd is null -- Added for Bug 6048854
4939: and prv.rt_strt_dt <= prv.rt_end_dt;
4940: --Commented for Bug 6048854
4941: --and prv.rt_end_dt = hr_api.g_eot;
4942: --
4943: --
4944: /*Commented for Bug 6048854
4945: cursor c_prv2 is

Line 4952: and prv.rt_end_dt <> hr_api.g_eot;

4948: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4949: and prv.per_in_ler_id = p_per_in_ler_id
4950: Bug 5376185 : Pick the latest non-recurring rate
4951: and prv.rt_strt_dt = prv.rt_end_dt
4952: and prv.rt_end_dt <> hr_api.g_eot;
4953: */
4954: --
4955: l_rt_val number := null;
4956: --

Line 5150: ,hr_api_transaction_steps step

5146: from wf_item_activity_statuses process
5147: ,wf_item_attribute_values choice_attribute
5148: ,wf_item_attribute_values submit_attribute
5149: ,wf_process_activities activity
5150: ,hr_api_transaction_steps step
5151: where activity.activity_name = 'HR_INDIVIDUAL_COMP_PRC'
5152: and activity.process_item_type = activity.activity_item_type
5153: and activity.instance_id = process.process_activity
5154: and process.activity_status = 'ACTIVE'

Line 5192: hr_api_transactions txn,

5188: -- re-wrote query for performance in case this function is used.
5189: select 'Y'
5190: from wf_item_activity_statuses process ,
5191: wf_process_activities activity ,
5192: hr_api_transactions txn,
5193: hr_api_transaction_steps step ,
5194: wf_item_attribute_values submit_attribute
5195: where activity.process_name = 'ROOT'
5196: and activity.process_item_type = activity.activity_item_type

Line 5193: hr_api_transaction_steps step ,

5189: select 'Y'
5190: from wf_item_activity_statuses process ,
5191: wf_process_activities activity ,
5192: hr_api_transactions txn,
5193: hr_api_transaction_steps step ,
5194: wf_item_attribute_values submit_attribute
5195: where activity.process_name = 'ROOT'
5196: and activity.process_item_type = activity.activity_item_type
5197: and activity.instance_id = process.process_activity

Line 5673: -- The function calls hr_api.return_concat_kf_segments to get the

5669: -- {Start Of Comments}
5670: --
5671: -- Description:
5672: -- Returns the display concatenated string for the segments1..30.
5673: -- The function calls hr_api.return_concat_kf_segments to get the
5674: -- concatenated segments.
5675: -- This function has been added to benutils as part of fix for bug 2599034
5676: -- Since there is a package HR_API present in PLD library and backend, it is
5677: -- conflicting with each other when we try to use the backend package from

Line 5676: -- Since there is a package HR_API present in PLD library and backend, it is

5672: -- Returns the display concatenated string for the segments1..30.
5673: -- The function calls hr_api.return_concat_kf_segments to get the
5674: -- concatenated segments.
5675: -- This function has been added to benutils as part of fix for bug 2599034
5676: -- Since there is a package HR_API present in PLD library and backend, it is
5677: -- conflicting with each other when we try to use the backend package from
5678: -- form. But hard-coding Apps. is not a good practice.
5679: -- Hence creating a wrapper for the hr_api.return_concat_kf_segments in
5680: -- benutils to accomplish the same.

Line 5679: -- Hence creating a wrapper for the hr_api.return_concat_kf_segments in

5675: -- This function has been added to benutils as part of fix for bug 2599034
5676: -- Since there is a package HR_API present in PLD library and backend, it is
5677: -- conflicting with each other when we try to use the backend package from
5678: -- form. But hard-coding Apps. is not a good practice.
5679: -- Hence creating a wrapper for the hr_api.return_concat_kf_segments in
5680: -- benutils to accomplish the same.
5681: --
5682: -- Pre-conditions:
5683: -- The id_flex_num and segments have been fully validated.

Line 5735: return hr_api.return_concat_kf_segments

5731: Return Varchar2
5732: is
5733: begin
5734: --
5735: return hr_api.return_concat_kf_segments
5736: (p_id_flex_num,
5737: p_application_id,
5738: p_id_flex_code,
5739: p_segment1,

Line 6125: and pdp.cvg_thru_dt = hr_api.g_eot

6121: select 'Y'
6122: from ben_elig_cvrd_dpnt_f pdp,
6123: ben_per_in_ler pil
6124: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
6125: and pdp.cvg_thru_dt = hr_api.g_eot
6126: -- and pdp.effective_end_date <> hr_api.g_eot In the unrestricted enrollment. may continue without per_in_ler update.why
6127: -- and pdp.per_in_ler_id = p_per_in_ler_id
6128: and (l_enrt_perd_strt_dt -1 ) between
6129: pdp.effective_start_date and pdp.effective_end_date

Line 6126: -- and pdp.effective_end_date <> hr_api.g_eot In the unrestricted enrollment. may continue without per_in_ler update.why

6122: from ben_elig_cvrd_dpnt_f pdp,
6123: ben_per_in_ler pil
6124: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
6125: and pdp.cvg_thru_dt = hr_api.g_eot
6126: -- and pdp.effective_end_date <> hr_api.g_eot In the unrestricted enrollment. may continue without per_in_ler update.why
6127: -- and pdp.per_in_ler_id = p_per_in_ler_id
6128: and (l_enrt_perd_strt_dt -1 ) between
6129: pdp.effective_start_date and pdp.effective_end_date
6130: and pdp.per_in_ler_id = pil.per_in_ler_id

Line 6141: --and pdp.cvg_thru_dt = hr_api.g_eot

6137: ben_per_in_ler pil,
6138: ben_prtt_enrt_rslt_f pnr,
6139: ben_prtt_enrt_rslt_f pen
6140: where pdp.dpnt_person_id = p_dpnt_person_id
6141: --and pdp.cvg_thru_dt = hr_api.g_eot
6142: and pdp.effective_end_date = hr_api.g_eot
6143: and pdp.prtt_enrt_rslt_id = pnr.prtt_enrt_rslt_id
6144: --and (l_enrt_perd_strt_dt -1 ) between pdp.effective_start_date
6145: -- and pdp.effective_end_date

Line 6142: and pdp.effective_end_date = hr_api.g_eot

6138: ben_prtt_enrt_rslt_f pnr,
6139: ben_prtt_enrt_rslt_f pen
6140: where pdp.dpnt_person_id = p_dpnt_person_id
6141: --and pdp.cvg_thru_dt = hr_api.g_eot
6142: and pdp.effective_end_date = hr_api.g_eot
6143: and pdp.prtt_enrt_rslt_id = pnr.prtt_enrt_rslt_id
6144: --and (l_enrt_perd_strt_dt -1 ) between pdp.effective_start_date
6145: -- and pdp.effective_end_date
6146: and pnr.pl_typ_id = pen.pl_typ_id

Line 6152: and pen.effective_end_date = hr_api.g_eot --new pen

6148: and pnr.prtt_enrt_rslt_id <> pen.prtt_enrt_rslt_id
6149: and pnr.prtt_enrt_rslt_stat_cd IS NULL
6150: --and pen.prtt_enrt_rslt_stat_cd IS NULL
6151: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id -- epe.pen
6152: and pen.effective_end_date = hr_api.g_eot --new pen
6153: and pnr.effective_end_date = hr_api.g_eot --old
6154: and pdp.per_in_ler_id = p_per_in_ler_id --9905474
6155: and pdp.per_in_ler_id = pil.per_in_ler_id
6156: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT') );

Line 6153: and pnr.effective_end_date = hr_api.g_eot --old

6149: and pnr.prtt_enrt_rslt_stat_cd IS NULL
6150: --and pen.prtt_enrt_rslt_stat_cd IS NULL
6151: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id -- epe.pen
6152: and pen.effective_end_date = hr_api.g_eot --new pen
6153: and pnr.effective_end_date = hr_api.g_eot --old
6154: and pdp.per_in_ler_id = p_per_in_ler_id --9905474
6155: and pdp.per_in_ler_id = pil.per_in_ler_id
6156: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT') );
6157: --