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.BEN_DETERMINE_RATES dependencies on BEN_ENRT_RT

Line 14: writes them to the ben_enrt_rt table. This process can only run in benmngle.

10: Name:
11: Determine Rates.
12: Purpose:
13: This process determines rates for either elctable choices or coverages, and
14: writes them to the ben_enrt_rt table. This process can only run in benmngle.
15: History:
16: Date Who Version What?
17: ---- --- ------- -----
18: 7 May 98 Ty Hayden 110.0 Created.

Line 38: ben_enrt_rt. Added location

34: or oipl).
35: 11 Aug 98 Ty Hayden 110.6 Added local variables l_pl_id etc.
36: 11 Aug 98 Ty Hayden 110.7 Fix to local variable placement.
37: 07 Oct 98 T Guy 115.2 Implemented schema changes for
38: ben_enrt_rt. Added location
39: debugging calls.Added message
40: numbers.
41: 18 Oct 98 T Guy 115.3 Added annual values and cmcd
42: values

Line 54: assignment for ben_enrt_rt

50: p_rt_start_dt, p_rt_start_dt_cd
51: p_rt_start_dt_rl
52: 23 Oct 98 T Guy 115.5 added person_id to main
53: 02 Nov 98 T Guy 115.6 fixed asn_on_enrt_flag
54: assignment for ben_enrt_rt
55: 02 Dec 98 T Guy 115.7 fixed mx_ann_elcn_val variable
56: assignment error.
57: 20 Dec 98 T Guy 115.8 Added in caching information
58: for the created enrollment rate.

Line 109: 03-Aug-00 mhoyes 115.34 - Bulk bind of ben_enrt_rt.

105: 28-Jun-00 mhoyes 115.32 - Moved eligibility cursor outside of
106: abr loop.
107: - Referenced elig per cache rather than
108: sql.
109: 03-Aug-00 mhoyes 115.34 - Bulk bind of ben_enrt_rt.
110: 08-Sep-00 kmahendr 115.35 - added more attributes to cursors-plan not in
111: programs - www#1186195- Variable rate profiles
112: overriden
113: 22-Sep-00 mhoyes 115.36 - Added calls clear down ATP and PTA function

Line 251: FROM ben_enrt_rt b

247: --
248: CURSOR c_rate(
249: l_elctbl_chc_id NUMBER) IS
250: SELECT b.val
251: FROM ben_enrt_rt b
252: WHERE b.acty_base_rt_id = p_acty_base_rt_id
253: AND b.elig_per_elctbl_chc_id = l_elctbl_chc_id;
254: CURSOR c_elig_per_elctbl_chc(
255: l_per_in_ler NUMBER) IS

Line 343: l_created_by ben_enrt_rt.created_by%TYPE;

339: l_currepe_row ben_determine_rates.g_curr_epe_rec;
340: --
341: l_elig_per_elctbl_chc_id1 NUMBER;
342: --
343: l_created_by ben_enrt_rt.created_by%TYPE;
344: l_creation_date ben_enrt_rt.creation_date%TYPE;
345: l_last_update_date ben_enrt_rt.last_update_date%TYPE;
346: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
347: l_last_update_login ben_enrt_rt.last_update_login%TYPE;

Line 344: l_creation_date ben_enrt_rt.creation_date%TYPE;

340: --
341: l_elig_per_elctbl_chc_id1 NUMBER;
342: --
343: l_created_by ben_enrt_rt.created_by%TYPE;
344: l_creation_date ben_enrt_rt.creation_date%TYPE;
345: l_last_update_date ben_enrt_rt.last_update_date%TYPE;
346: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
347: l_last_update_login ben_enrt_rt.last_update_login%TYPE;
348: l_request_id ben_enrt_rt.request_id%TYPE

Line 345: l_last_update_date ben_enrt_rt.last_update_date%TYPE;

341: l_elig_per_elctbl_chc_id1 NUMBER;
342: --
343: l_created_by ben_enrt_rt.created_by%TYPE;
344: l_creation_date ben_enrt_rt.creation_date%TYPE;
345: l_last_update_date ben_enrt_rt.last_update_date%TYPE;
346: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
347: l_last_update_login ben_enrt_rt.last_update_login%TYPE;
348: l_request_id ben_enrt_rt.request_id%TYPE
349: := fnd_global.conc_request_id;

Line 346: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;

342: --
343: l_created_by ben_enrt_rt.created_by%TYPE;
344: l_creation_date ben_enrt_rt.creation_date%TYPE;
345: l_last_update_date ben_enrt_rt.last_update_date%TYPE;
346: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
347: l_last_update_login ben_enrt_rt.last_update_login%TYPE;
348: l_request_id ben_enrt_rt.request_id%TYPE
349: := fnd_global.conc_request_id;
350: l_program_application_id ben_enrt_rt.program_application_id%TYPE

Line 347: l_last_update_login ben_enrt_rt.last_update_login%TYPE;

343: l_created_by ben_enrt_rt.created_by%TYPE;
344: l_creation_date ben_enrt_rt.creation_date%TYPE;
345: l_last_update_date ben_enrt_rt.last_update_date%TYPE;
346: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
347: l_last_update_login ben_enrt_rt.last_update_login%TYPE;
348: l_request_id ben_enrt_rt.request_id%TYPE
349: := fnd_global.conc_request_id;
350: l_program_application_id ben_enrt_rt.program_application_id%TYPE
351: := fnd_global.prog_appl_id;

Line 348: l_request_id ben_enrt_rt.request_id%TYPE

344: l_creation_date ben_enrt_rt.creation_date%TYPE;
345: l_last_update_date ben_enrt_rt.last_update_date%TYPE;
346: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
347: l_last_update_login ben_enrt_rt.last_update_login%TYPE;
348: l_request_id ben_enrt_rt.request_id%TYPE
349: := fnd_global.conc_request_id;
350: l_program_application_id ben_enrt_rt.program_application_id%TYPE
351: := fnd_global.prog_appl_id;
352: l_program_id ben_enrt_rt.program_id%TYPE

Line 350: l_program_application_id ben_enrt_rt.program_application_id%TYPE

346: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;
347: l_last_update_login ben_enrt_rt.last_update_login%TYPE;
348: l_request_id ben_enrt_rt.request_id%TYPE
349: := fnd_global.conc_request_id;
350: l_program_application_id ben_enrt_rt.program_application_id%TYPE
351: := fnd_global.prog_appl_id;
352: l_program_id ben_enrt_rt.program_id%TYPE
353: := fnd_global.conc_program_id;
354: l_program_update_date ben_enrt_rt.program_update_date%TYPE

Line 352: l_program_id ben_enrt_rt.program_id%TYPE

348: l_request_id ben_enrt_rt.request_id%TYPE
349: := fnd_global.conc_request_id;
350: l_program_application_id ben_enrt_rt.program_application_id%TYPE
351: := fnd_global.prog_appl_id;
352: l_program_id ben_enrt_rt.program_id%TYPE
353: := fnd_global.conc_program_id;
354: l_program_update_date ben_enrt_rt.program_update_date%TYPE
355: := SYSDATE;
356: l_object_version_number ben_enrt_rt.object_version_number%TYPE := 1;

Line 354: l_program_update_date ben_enrt_rt.program_update_date%TYPE

350: l_program_application_id ben_enrt_rt.program_application_id%TYPE
351: := fnd_global.prog_appl_id;
352: l_program_id ben_enrt_rt.program_id%TYPE
353: := fnd_global.conc_program_id;
354: l_program_update_date ben_enrt_rt.program_update_date%TYPE
355: := SYSDATE;
356: l_object_version_number ben_enrt_rt.object_version_number%TYPE := 1;
357: l_no VARCHAR2(1) := 'N';
358: -- the null variables are used to ensure the INSERT statement contains bind

Line 356: l_object_version_number ben_enrt_rt.object_version_number%TYPE := 1;

352: l_program_id ben_enrt_rt.program_id%TYPE
353: := fnd_global.conc_program_id;
354: l_program_update_date ben_enrt_rt.program_update_date%TYPE
355: := SYSDATE;
356: l_object_version_number ben_enrt_rt.object_version_number%TYPE := 1;
357: l_no VARCHAR2(1) := 'N';
358: -- the null variables are used to ensure the INSERT statement contains bind
359: -- parameters and increases shareability
360: l_varchar2_null VARCHAR2(1); -- automatically set to NULL

Line 427: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;

423: l_iss_val l_number_table_type;
424: l_enrt_rt_id_tab l_number_15_table_type; -- 2897152
425:
426: --
427: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
428: l_enrt_rt_ctfn_id ben_enrt_rt_ctfn.enrt_rt_ctfn_id%type;
429: l_old_val NUMBER;
430: l_dummy varchar2(1);
431: --

Line 428: l_enrt_rt_ctfn_id ben_enrt_rt_ctfn.enrt_rt_ctfn_id%type;

424: l_enrt_rt_id_tab l_number_15_table_type; -- 2897152
425:
426: --
427: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
428: l_enrt_rt_ctfn_id ben_enrt_rt_ctfn.enrt_rt_ctfn_id%type;
429: l_old_val NUMBER;
430: l_dummy varchar2(1);
431: --
432: cursor c_enrt_rt_id is

Line 433: select ben_enrt_rt_s.nextval

429: l_old_val NUMBER;
430: l_dummy varchar2(1);
431: --
432: cursor c_enrt_rt_id is
433: select ben_enrt_rt_s.nextval
434: from sys.dual;
435: --
436: /* cursor c_enrt_ctfn(p_acty_base_rt_id number,
437: p_elig_per_elctbl_chc_id number) is

Line 441: from ben_enrt_rt ecr,

437: p_elig_per_elctbl_chc_id number) is
438: select ecr.enrt_rt_id,
439: abc.enrt_ctfn_typ_cd,
440: abc.rqd_flag
441: from ben_enrt_rt ecr,
442: ben_enrt_bnft enb,
443: BEN_ACTY_BASE_RT_CTFN_F abc
444: where ecr.acty_base_rt_id = p_acty_base_rt_id
445: and ecr.business_group_id = p_business_group_id

Line 457: from ben_enrt_rt ecr,

453: p_elig_per_elctbl_chc_id number) is
454: select ecr.enrt_rt_id,
455: abc.enrt_ctfn_typ_cd,
456: abc.rqd_flag
457: from ben_enrt_rt ecr,
458: BEN_ACTY_BASE_RT_CTFN_F abc
459: where ecr.acty_base_rt_id = p_acty_base_rt_id
460: and ecr.business_group_id = p_business_group_id
461: and ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id

Line 470: from ben_enrt_rt ecr,

466: p_elig_per_elctbl_chc_id number) is
467: select ecr.enrt_rt_id,
468: abc.enrt_ctfn_typ_cd,
469: abc.rqd_flag
470: from ben_enrt_rt ecr,
471: ben_enrt_bnft enb,
472: BEN_ACTY_BASE_RT_CTFN_F abc
473: where ecr.acty_base_rt_id = p_acty_base_rt_id
474: and ecr.business_group_id = p_business_group_id

Line 483: from ben_enrt_rt_ctfn erc

479: --
480: cursor c_enrt_ctfn_exists (p_enrt_rt_id number,
481: p_enrt_ctfn_typ_cd varchar2) is
482: select null
483: from ben_enrt_rt_ctfn erc
484: where erc.enrt_rt_id = p_enrt_rt_id
485: and erc.enrt_ctfn_typ_cd = p_enrt_ctfn_typ_cd;
486: --
487: -- 2897152

Line 1111: -- in ben_enrt_rt then nullify chc_id when bnft_id is not null;

1107:
1108: --
1109: -- Since enrt_bnft_id and elig_per_elctbl_chc_id are
1110: -- mutually exclusive
1111: -- in ben_enrt_rt then nullify chc_id when bnft_id is not null;
1112: --
1113:
1114: IF p_enrt_bnft_id IS NOT NULL THEN
1115: l_elig_per_elctbl_chc_id1 := NULL;

Line 1135: -- GLOBALCWB : No need to populate the ben_enrt_rt table.

1131: hr_utility.set_location('Insert ECR: ' || l_package, 5);
1132: end if;
1133:
1134: --
1135: -- GLOBALCWB : No need to populate the ben_enrt_rt table.
1136: --
1137:
1138: if nvl(p_mode, 'X') <> 'W' then
1139: --

Line 1213: INSERT INTO ben_enrt_rt

1209: ;
1210: --
1211: else
1212: --
1213: INSERT INTO ben_enrt_rt
1214: (
1215: enrt_rt_id,
1216: acty_typ_cd,
1217: tx_typ_cd,

Line 1308: ben_enrt_rt_s.nextval,

1304: pp_in_yr_used_num,
1305: ordr_num,
1306: iss_val)
1307: VALUES(
1308: ben_enrt_rt_s.nextval,
1309: l_acty_typ_cd(i),
1310: l_tx_typ_cd(i),
1311: p_ctfn_rqd_flag,
1312: p_dflt_flag,

Line 1409: INSERT INTO ben_enrt_rt

1405: --
1406: else
1407: --
1408: FORALL i IN p_acty_base_rt_id_table.FIRST .. p_acty_base_rt_id_table.LAST
1409: INSERT INTO ben_enrt_rt
1410: (
1411: enrt_rt_id,
1412: acty_typ_cd,
1413: tx_typ_cd,

Line 1504: ben_enrt_rt_s.nextval,

1500: pp_in_yr_used_num,
1501: ordr_num,
1502: iss_val)
1503: VALUES(
1504: ben_enrt_rt_s.nextval,
1505: l_acty_typ_cd(i),
1506: l_tx_typ_cd(i),
1507: p_ctfn_rqd_flag,
1508: p_dflt_flag,

Line 1633: Delete from Ben_enrt_rt

1629: if g_debug then
1630: hr_utility.set_location(' enrt rt_id '||l_enrt_rt_id_tab(l_nsuv_num) , 99 );
1631: end if ;
1632:
1633: Delete from Ben_enrt_rt
1634: where val is null
1635: and rt_mlt_cd = l_rt_mlt_cd(l_nsuv_num)
1636: and acty_base_rt_id = p_acty_base_rt_id_table(l_nsuv_num)
1637: and business_group_id = p_business_group_id

Line 1663: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn

1659: -- bug#4126093
1660: open c_enrt_ctfn_exists (l_enrt_ctfn.enrt_rt_id,l_enrt_ctfn.enrt_ctfn_typ_cd);
1661: fetch c_enrt_ctfn_exists into l_dummy;
1662: if c_enrt_ctfn_exists%notfound then
1663: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn
1664: (p_validate => false
1665: ,p_enrt_rt_ctfn_id => l_enrt_rt_ctfn_id
1666: ,p_enrt_ctfn_typ_cd => l_enrt_ctfn.enrt_ctfn_typ_cd
1667: ,p_rqd_flag => l_enrt_ctfn.rqd_flag

Line 1690: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn

1686: --
1687: open c_enrt_ctfn_exists (l_enrt_ctfn.enrt_rt_id,l_enrt_ctfn.enrt_ctfn_typ_cd);
1688: fetch c_enrt_ctfn_exists into l_dummy;
1689: if c_enrt_ctfn_exists%notfound then
1690: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn
1691: (p_validate => false
1692: ,p_enrt_rt_ctfn_id => l_enrt_rt_ctfn_id
1693: ,p_enrt_ctfn_typ_cd => l_enrt_ctfn.enrt_ctfn_typ_cd
1694: ,p_rqd_flag => l_enrt_ctfn.rqd_flag