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 249: FROM ben_enrt_rt b

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

Line 341: l_created_by ben_enrt_rt.created_by%TYPE;

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

Line 342: l_creation_date ben_enrt_rt.creation_date%TYPE;

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

Line 343: l_last_update_date ben_enrt_rt.last_update_date%TYPE;

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

Line 344: l_last_updated_by ben_enrt_rt.last_updated_by%TYPE;

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

Line 345: l_last_update_login ben_enrt_rt.last_update_login%TYPE;

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

Line 346: l_request_id ben_enrt_rt.request_id%TYPE

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

Line 348: l_program_application_id ben_enrt_rt.program_application_id%TYPE

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

Line 350: l_program_id ben_enrt_rt.program_id%TYPE

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

Line 352: l_program_update_date ben_enrt_rt.program_update_date%TYPE

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

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

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

Line 425: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;

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

Line 426: l_enrt_rt_ctfn_id ben_enrt_rt_ctfn.enrt_rt_ctfn_id%type;

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

Line 431: select ben_enrt_rt_s.nextval

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

Line 439: from ben_enrt_rt ecr,

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

Line 455: from ben_enrt_rt ecr,

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

Line 468: from ben_enrt_rt ecr,

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

Line 481: from ben_enrt_rt_ctfn erc

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

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

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

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

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

Line 1211: INSERT INTO ben_enrt_rt

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

Line 1306: ben_enrt_rt_s.nextval,

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

Line 1407: INSERT INTO ben_enrt_rt

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

Line 1502: ben_enrt_rt_s.nextval,

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

Line 1631: Delete from Ben_enrt_rt

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

Line 1661: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn

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

Line 1688: ben_enrt_rt_ctfn_api.create_enrt_rt_ctfn

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