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 3177: if p_new_column = hr_api.g_eot then

3173: -- Bug 1167917 Do not trigger date oabany's for null nor end of time.
3174: -- eot is a date that should work like null.
3175: -- Bug#2001857-null value must be treated differently as the condition above checks
3176: -- and both the values are null then false is returnedi-null condition masked
3177: if p_new_column = hr_api.g_eot then
3178: -- or p_new_column is null then
3179: hr_utility.set_location('FALSE2',10);
3180: return FALSE;
3181: else

Line 3187: p_new_column = hr_api.g_eot)

3183: return TRUE;
3184: end if;
3185: elsif ((p_new_value = 'NULL')
3186: AND (p_new_column IS NULL or
3187: p_new_column = hr_api.g_eot)
3188: )
3189: then
3190: -- Bug 1167017, treat eot as null
3191: hr_utility.set_location('TRUE4',10);

Line 3195: p_new_column <> hr_api.g_eot)

3191: hr_utility.set_location('TRUE4',10);
3192: return TRUE;
3193: elsif ((p_new_value = 'NULL')
3194: AND (p_new_column IS NOT NULL) and
3195: p_new_column <> hr_api.g_eot)
3196: then
3197: hr_utility.set_location('FALSE5',10);
3198: return FALSE;
3199: elsif p_new_value = 'ENDTM' and p_new_column = hr_api.g_eot then

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

3195: p_new_column <> hr_api.g_eot)
3196: then
3197: hr_utility.set_location('FALSE5',10);
3198: return FALSE;
3199: elsif p_new_value = 'ENDTM' and p_new_column = hr_api.g_eot then
3200: hr_utility.set_location('TRUE5',10);
3201: return true;
3202: elsif ((p_new_column IS NOT NULL)
3203: AND (to_char(p_new_column) = p_new_value)

Line 3850: if p_date = hr_api.g_eot then

3846: begin
3847: --
3848: hr_utility.set_location ('Entering '||l_package,10);
3849: --
3850: if p_date = hr_api.g_eot then
3851: --
3852: l_date := null;
3853: --
3854: else

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

4672: and prv.per_in_ler_id = p_per_in_ler_id
4673: and prv.prtt_rt_val_stat_cd is null -- Added for Bug 6048854
4674: and prv.rt_strt_dt <= prv.rt_end_dt;
4675: --Commented for Bug 6048854
4676: --and prv.rt_end_dt = hr_api.g_eot;
4677: --
4678: --
4679:
4680: /* Commented for Bug 6048854

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

4684: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4685: and prv.per_in_ler_id = p_per_in_ler_id
4686: Bug 5376185 : Pick the latest non-recurring rate
4687: and prv.rt_strt_dt = prv.rt_end_dt
4688: and prv.rt_end_dt <> hr_api.g_eot;
4689: */
4690: --
4691: l_rt_val number := null;
4692: --

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

4729: and prv.per_in_ler_id = p_per_in_ler_id
4730: and prv.prtt_rt_val_stat_cd is null -- Added for Bug 6048854
4731: and prv.rt_strt_dt <= prv.rt_end_dt;
4732: --Commented for Bug 6048854
4733: --and prv.rt_end_dt = hr_api.g_eot;
4734: --
4735: --
4736: /* Commented for Bug 6048854
4737: cursor c_prv2 is

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

4740: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4741: and prv.per_in_ler_id = p_per_in_ler_id
4742: Bug 5376185 : Pick the latest non-recurring rate
4743: and prv.rt_strt_dt = prv.rt_end_dt
4744: and prv.rt_end_dt <> hr_api.g_eot;
4745: */
4746: --
4747: l_rt_val number := null;
4748: --

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

4779: select to_char(nvl(prv.ann_rt_val,0))||'^'|| to_char(nvl(prv.cmcd_rt_val,0))||'^'||to_char(nvl(prv.rt_val,0))
4780: from ben_prtt_rt_val prv
4781: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4782: and prv.per_in_ler_id = p_per_in_ler_id
4783: and prv.rt_end_dt = hr_api.g_eot;
4784: --
4785: l_rt_val varchar2(100) := null;
4786: --
4787: begin

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

4812: and prv.per_in_ler_id = p_per_in_ler_id
4813: and prv.prtt_rt_val_stat_cd is null -- Added for Bug 6048854
4814: and prv.rt_strt_dt <= prv.rt_end_dt;
4815: --Commented for Bug 6048854
4816: --and prv.rt_end_dt = hr_api.g_eot;
4817: --
4818: --
4819: /*Commented for Bug 6048854
4820: cursor c_prv2 is

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

4823: where prv.prtt_rt_val_id = p_prtt_rt_val_id
4824: and prv.per_in_ler_id = p_per_in_ler_id
4825: Bug 5376185 : Pick the latest non-recurring rate
4826: and prv.rt_strt_dt = prv.rt_end_dt
4827: and prv.rt_end_dt <> hr_api.g_eot;
4828: */
4829: --
4830: l_rt_val number := null;
4831: --

Line 5025: ,hr_api_transaction_steps step

5021: from wf_item_activity_statuses process
5022: ,wf_item_attribute_values choice_attribute
5023: ,wf_item_attribute_values submit_attribute
5024: ,wf_process_activities activity
5025: ,hr_api_transaction_steps step
5026: where activity.activity_name = 'HR_INDIVIDUAL_COMP_PRC'
5027: and activity.process_item_type = activity.activity_item_type
5028: and activity.instance_id = process.process_activity
5029: and process.activity_status = 'ACTIVE'

Line 5067: hr_api_transactions txn,

5063: -- re-wrote query for performance in case this function is used.
5064: select 'Y'
5065: from wf_item_activity_statuses process ,
5066: wf_process_activities activity ,
5067: hr_api_transactions txn,
5068: hr_api_transaction_steps step ,
5069: wf_item_attribute_values submit_attribute
5070: where activity.process_name = 'ROOT'
5071: and activity.process_item_type = activity.activity_item_type

Line 5068: hr_api_transaction_steps step ,

5064: select 'Y'
5065: from wf_item_activity_statuses process ,
5066: wf_process_activities activity ,
5067: hr_api_transactions txn,
5068: hr_api_transaction_steps step ,
5069: wf_item_attribute_values submit_attribute
5070: where activity.process_name = 'ROOT'
5071: and activity.process_item_type = activity.activity_item_type
5072: and activity.instance_id = process.process_activity

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

5544: -- {Start Of Comments}
5545: --
5546: -- Description:
5547: -- Returns the display concatenated string for the segments1..30.
5548: -- The function calls hr_api.return_concat_kf_segments to get the
5549: -- concatenated segments.
5550: -- This function has been added to benutils as part of fix for bug 2599034
5551: -- Since there is a package HR_API present in PLD library and backend, it is
5552: -- conflicting with each other when we try to use the backend package from

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

5547: -- Returns the display concatenated string for the segments1..30.
5548: -- The function calls hr_api.return_concat_kf_segments to get the
5549: -- concatenated segments.
5550: -- This function has been added to benutils as part of fix for bug 2599034
5551: -- Since there is a package HR_API present in PLD library and backend, it is
5552: -- conflicting with each other when we try to use the backend package from
5553: -- form. But hard-coding Apps. is not a good practice.
5554: -- Hence creating a wrapper for the hr_api.return_concat_kf_segments in
5555: -- benutils to accomplish the same.

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

5550: -- This function has been added to benutils as part of fix for bug 2599034
5551: -- Since there is a package HR_API present in PLD library and backend, it is
5552: -- conflicting with each other when we try to use the backend package from
5553: -- form. But hard-coding Apps. is not a good practice.
5554: -- Hence creating a wrapper for the hr_api.return_concat_kf_segments in
5555: -- benutils to accomplish the same.
5556: --
5557: -- Pre-conditions:
5558: -- The id_flex_num and segments have been fully validated.

Line 5610: return hr_api.return_concat_kf_segments

5606: Return Varchar2
5607: is
5608: begin
5609: --
5610: return hr_api.return_concat_kf_segments
5611: (p_id_flex_num,
5612: p_application_id,
5613: p_id_flex_code,
5614: p_segment1,

Line 6000: and pdp.cvg_thru_dt = hr_api.g_eot

5996: select 'Y'
5997: from ben_elig_cvrd_dpnt_f pdp,
5998: ben_per_in_ler pil
5999: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
6000: and pdp.cvg_thru_dt = hr_api.g_eot
6001: -- and pdp.effective_end_date <> hr_api.g_eot In the unrestricted enrollment. may continue without per_in_ler update.why
6002: -- and pdp.per_in_ler_id = p_per_in_ler_id
6003: and (l_enrt_perd_strt_dt -1 ) between
6004: pdp.effective_start_date and pdp.effective_end_date

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

5997: from ben_elig_cvrd_dpnt_f pdp,
5998: ben_per_in_ler pil
5999: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
6000: and pdp.cvg_thru_dt = hr_api.g_eot
6001: -- and pdp.effective_end_date <> hr_api.g_eot In the unrestricted enrollment. may continue without per_in_ler update.why
6002: -- and pdp.per_in_ler_id = p_per_in_ler_id
6003: and (l_enrt_perd_strt_dt -1 ) between
6004: pdp.effective_start_date and pdp.effective_end_date
6005: and pdp.per_in_ler_id = pil.per_in_ler_id

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

6012: ben_per_in_ler pil,
6013: ben_prtt_enrt_rslt_f pnr,
6014: ben_prtt_enrt_rslt_f pen
6015: where pdp.dpnt_person_id = p_dpnt_person_id
6016: --and pdp.cvg_thru_dt = hr_api.g_eot
6017: and pdp.effective_end_date = hr_api.g_eot
6018: and pdp.prtt_enrt_rslt_id = pnr.prtt_enrt_rslt_id
6019: --and (l_enrt_perd_strt_dt -1 ) between pdp.effective_start_date
6020: -- and pdp.effective_end_date

Line 6017: and pdp.effective_end_date = hr_api.g_eot

6013: ben_prtt_enrt_rslt_f pnr,
6014: ben_prtt_enrt_rslt_f pen
6015: where pdp.dpnt_person_id = p_dpnt_person_id
6016: --and pdp.cvg_thru_dt = hr_api.g_eot
6017: and pdp.effective_end_date = hr_api.g_eot
6018: and pdp.prtt_enrt_rslt_id = pnr.prtt_enrt_rslt_id
6019: --and (l_enrt_perd_strt_dt -1 ) between pdp.effective_start_date
6020: -- and pdp.effective_end_date
6021: and pnr.pl_typ_id = pen.pl_typ_id

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

6022: and pnr.prtt_enrt_rslt_id <> pen.prtt_enrt_rslt_id
6023: and pnr.prtt_enrt_rslt_stat_cd IS NULL
6024: --and pen.prtt_enrt_rslt_stat_cd IS NULL
6025: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id -- epe.pen
6026: and pen.effective_end_date = hr_api.g_eot --new pen
6027: and pnr.effective_end_date = hr_api.g_eot --old
6028: -- and pdp.per_in_ler_id = p_per_in_ler_id -- doesnot work for LE
6029: and pdp.per_in_ler_id = pil.per_in_ler_id
6030: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT') );

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

6023: and pnr.prtt_enrt_rslt_stat_cd IS NULL
6024: --and pen.prtt_enrt_rslt_stat_cd IS NULL
6025: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id -- epe.pen
6026: and pen.effective_end_date = hr_api.g_eot --new pen
6027: and pnr.effective_end_date = hr_api.g_eot --old
6028: -- and pdp.per_in_ler_id = p_per_in_ler_id -- doesnot work for LE
6029: and pdp.per_in_ler_id = pil.per_in_ler_id
6030: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT') );
6031: --