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_ELIG_DPNT_API dependencies on BEN_ELIG_DPNT

Line 1: Package Body ben_ELIG_DPNT_api as

1: Package Body ben_ELIG_DPNT_api as
2: /* $Header: beegdapi.pkb 120.11.12010000.5 2009/11/03 09:51:23 sallumwa ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' ben_ELIG_DPNT_api.';

2: /* $Header: beegdapi.pkb 120.11.12010000.5 2009/11/03 09:51:23 sallumwa ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_ELIG_DPNT_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_ELIG_DPNT >----------------------|
10: -- ----------------------------------------------------------------------------

Line 70: l_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;

66: ) is
67: --
68: -- Declare cursors and local variables
69: --
70: l_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;
71: l_proc varchar2(72) := g_package||'create_ELIG_DPNT';
72: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;
73: --
74: begin

Line 72: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;

68: -- Declare cursors and local variables
69: --
70: l_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;
71: l_proc varchar2(72) := g_package||'create_ELIG_DPNT';
72: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;
73: --
74: begin
75: --
76: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 90: ben_ELIG_DPNT_bk1.create_ELIG_DPNT_b

86: begin
87: --
88: -- Start of API User Hook for the before hook of create_ELIG_DPNT
89: --
90: ben_ELIG_DPNT_bk1.create_ELIG_DPNT_b
91: (
92: p_create_dt => p_create_dt
93: ,p_elig_strt_dt => p_elig_strt_dt
94: ,p_elig_thru_dt => p_elig_thru_dt

Line 215: ben_ELIG_DPNT_bk1.create_ELIG_DPNT_a

211: begin
212: --
213: -- Start of API User Hook for the after hook of create_ELIG_DPNT
214: --
215: ben_ELIG_DPNT_bk1.create_ELIG_DPNT_a
216: (
217: p_elig_dpnt_id => l_elig_dpnt_id
218: ,p_create_dt => p_create_dt
219: ,p_elig_strt_dt => p_elig_strt_dt

Line 390: l_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;

386: l_new_rec ben_egd_ler.g_egd_ler_rec;
387: --
388: -- Declare cursors and local variables
389: --
390: l_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;
391: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;
392: --
393: l_created_by ben_elig_dpnt.created_by%TYPE;
394: l_creation_date ben_elig_dpnt.creation_date%TYPE;

Line 391: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;

387: --
388: -- Declare cursors and local variables
389: --
390: l_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;
391: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;
392: --
393: l_created_by ben_elig_dpnt.created_by%TYPE;
394: l_creation_date ben_elig_dpnt.creation_date%TYPE;
395: l_last_update_date ben_elig_dpnt.last_update_date%TYPE;

Line 393: l_created_by ben_elig_dpnt.created_by%TYPE;

389: --
390: l_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;
391: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;
392: --
393: l_created_by ben_elig_dpnt.created_by%TYPE;
394: l_creation_date ben_elig_dpnt.creation_date%TYPE;
395: l_last_update_date ben_elig_dpnt.last_update_date%TYPE;
396: l_last_updated_by ben_elig_dpnt.last_updated_by%TYPE;
397: l_last_update_login ben_elig_dpnt.last_update_login%TYPE;

Line 394: l_creation_date ben_elig_dpnt.creation_date%TYPE;

390: l_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%TYPE;
391: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;
392: --
393: l_created_by ben_elig_dpnt.created_by%TYPE;
394: l_creation_date ben_elig_dpnt.creation_date%TYPE;
395: l_last_update_date ben_elig_dpnt.last_update_date%TYPE;
396: l_last_updated_by ben_elig_dpnt.last_updated_by%TYPE;
397: l_last_update_login ben_elig_dpnt.last_update_login%TYPE;
398: --

Line 395: l_last_update_date ben_elig_dpnt.last_update_date%TYPE;

391: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;
392: --
393: l_created_by ben_elig_dpnt.created_by%TYPE;
394: l_creation_date ben_elig_dpnt.creation_date%TYPE;
395: l_last_update_date ben_elig_dpnt.last_update_date%TYPE;
396: l_last_updated_by ben_elig_dpnt.last_updated_by%TYPE;
397: l_last_update_login ben_elig_dpnt.last_update_login%TYPE;
398: --
399: Cursor C_Sel1 is select ben_elig_dpnt_s.nextval from sys.dual;

Line 396: l_last_updated_by ben_elig_dpnt.last_updated_by%TYPE;

392: --
393: l_created_by ben_elig_dpnt.created_by%TYPE;
394: l_creation_date ben_elig_dpnt.creation_date%TYPE;
395: l_last_update_date ben_elig_dpnt.last_update_date%TYPE;
396: l_last_updated_by ben_elig_dpnt.last_updated_by%TYPE;
397: l_last_update_login ben_elig_dpnt.last_update_login%TYPE;
398: --
399: Cursor C_Sel1 is select ben_elig_dpnt_s.nextval from sys.dual;
400: --

Line 397: l_last_update_login ben_elig_dpnt.last_update_login%TYPE;

393: l_created_by ben_elig_dpnt.created_by%TYPE;
394: l_creation_date ben_elig_dpnt.creation_date%TYPE;
395: l_last_update_date ben_elig_dpnt.last_update_date%TYPE;
396: l_last_updated_by ben_elig_dpnt.last_updated_by%TYPE;
397: l_last_update_login ben_elig_dpnt.last_update_login%TYPE;
398: --
399: Cursor C_Sel1 is select ben_elig_dpnt_s.nextval from sys.dual;
400: --
401: begin

Line 399: Cursor C_Sel1 is select ben_elig_dpnt_s.nextval from sys.dual;

395: l_last_update_date ben_elig_dpnt.last_update_date%TYPE;
396: l_last_updated_by ben_elig_dpnt.last_updated_by%TYPE;
397: l_last_update_login ben_elig_dpnt.last_update_login%TYPE;
398: --
399: Cursor C_Sel1 is select ben_elig_dpnt_s.nextval from sys.dual;
400: --
401: begin
402: --
403: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 418: insert into ben_elig_dpnt

414: --
415: ben_egd_shd.g_api_dml := true; -- Set the api dml status
416: --
417: hr_utility.set_location('Insert EGD: '||l_proc, 5);
418: insert into ben_elig_dpnt
419: ( elig_dpnt_id,
420: create_dt,
421: elig_strt_dt,
422: elig_thru_dt,

Line 472: ( ben_elig_dpnt_s.nextval,

468: program_update_date,
469: object_version_number
470: )
471: Values
472: ( ben_elig_dpnt_s.nextval,
473: p_create_dt,
474: p_elig_strt_dt,
475: p_elig_thru_dt,
476: p_ovrdn_flag,

Line 652: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;

648: --
649: -- Declare cursors and local variables
650: --
651: l_proc varchar2(72) := g_package||'update_ELIG_DPNT';
652: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;
653: --
654: begin
655: --
656: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 672: ben_ELIG_DPNT_bk2.update_ELIG_DPNT_b

668: begin
669: --
670: -- Start of API User Hook for the before hook of update_ELIG_DPNT
671: --
672: ben_ELIG_DPNT_bk2.update_ELIG_DPNT_b
673: (
674: p_elig_dpnt_id => p_elig_dpnt_id
675: ,p_create_dt => p_create_dt
676: ,p_elig_strt_dt => p_elig_strt_dt

Line 798: ben_ELIG_DPNT_bk2.update_ELIG_DPNT_a

794: begin
795: --
796: -- Start of API User Hook for the after hook of update_ELIG_DPNT
797: --
798: ben_ELIG_DPNT_bk2.update_ELIG_DPNT_a
799: (
800: p_elig_dpnt_id => p_elig_dpnt_id
801: ,p_create_dt => p_create_dt
802: ,p_elig_strt_dt => p_elig_strt_dt

Line 974: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;

970: l_old_rec ben_egd_ler.g_egd_ler_rec;
971: l_new_rec ben_egd_ler.g_egd_ler_rec;
972: --
973: l_rec ben_egd_shd.g_rec_type;
974: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;
975: --
976: begin
977: --
978: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1054: -- Update the ben_elig_dpnt Row

1050: --
1051: l_object_version_number := p_object_version_number+1;
1052: ben_egd_shd.g_api_dml := true; -- Set the api dml status
1053: --
1054: -- Update the ben_elig_dpnt Row
1055: --
1056: update ben_elig_dpnt
1057: set
1058: elig_dpnt_id = l_rec.elig_dpnt_id,

Line 1056: update ben_elig_dpnt

1052: ben_egd_shd.g_api_dml := true; -- Set the api dml status
1053: --
1054: -- Update the ben_elig_dpnt Row
1055: --
1056: update ben_elig_dpnt
1057: set
1058: elig_dpnt_id = l_rec.elig_dpnt_id,
1059: create_dt = l_rec.create_dt,
1060: elig_strt_dt = l_rec.elig_strt_dt,

Line 1191: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;

1187: --
1188: -- Declare cursors and local variables
1189: --
1190: l_proc varchar2(72) := g_package||'update_ELIG_DPNT';
1191: l_object_version_number ben_elig_dpnt.object_version_number%TYPE;
1192: --
1193: begin
1194: --
1195: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 1212: ben_ELIG_DPNT_bk3.delete_ELIG_DPNT_b

1208: begin
1209: --
1210: -- Start of API User Hook for the before hook of delete_ELIG_DPNT
1211: --
1212: ben_ELIG_DPNT_bk3.delete_ELIG_DPNT_b
1213: (
1214: p_elig_dpnt_id => p_elig_dpnt_id
1215: ,p_object_version_number => p_object_version_number
1216: ,p_effective_date => trunc(p_effective_date)

Line 1240: ben_ELIG_DPNT_bk3.delete_ELIG_DPNT_a

1236: begin
1237: --
1238: -- Start of API User Hook for the after hook of delete_ELIG_DPNT
1239: --
1240: ben_ELIG_DPNT_bk3.delete_ELIG_DPNT_a
1241: (
1242: p_elig_dpnt_id => p_elig_dpnt_id
1243: ,p_object_version_number => l_object_version_number
1244: ,p_effective_date => trunc(p_effective_date)

Line 1438: from ben_elig_dpnt egd,

1434: egd.dpnt_person_id,
1435: egd.per_in_ler_id,
1436: epe.prtt_enrt_rslt_id,
1437: egd.object_version_number
1438: from ben_elig_dpnt egd,
1439: ben_elig_per_elctbl_chc epe,
1440: ben_per_in_ler pil
1441: where egd.elig_dpnt_id = p_elig_dpnt_id
1442: and egd.business_group_id = p_business_group_id

Line 1660: ben_elig_dpnt_api.update_elig_dpnt(

1656: p_datetrack_mode => hr_api.g_zap,
1657: p_multi_row_actn => true,
1658: p_called_from => 'beegdapi' );
1659: --
1660: ben_elig_dpnt_api.update_elig_dpnt(
1661: p_elig_dpnt_id => p_elig_dpnt_id,
1662: p_elig_cvrd_dpnt_id => null,
1663: p_effective_date => p_effective_date,
1664: p_business_group_id => p_business_group_id,

Line 1822: ben_elig_dpnt_api.update_elig_dpnt(

1818: p_program_id => fnd_global.conc_program_id,
1819: p_request_id => fnd_global.conc_request_id,
1820: p_program_update_date => sysdate);
1821: --
1822: ben_elig_dpnt_api.update_elig_dpnt(
1823: p_elig_dpnt_id => p_elig_dpnt_id,
1824: p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
1825: p_effective_date => p_effective_date,
1826: p_business_group_id => p_business_group_id,

Line 2135: p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)

2131: --
2132: -- Function to get the eligible dependent record.
2133: --
2134: function get_elig_dpnt_rec(p_elig_dpnt_id in number,
2135: p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)
2136: return boolean is
2137: --
2138: cursor c_egd is
2139: select egd.*

Line 2140: from ben_elig_dpnt egd

2136: return boolean is
2137: --
2138: cursor c_egd is
2139: select egd.*
2140: from ben_elig_dpnt egd
2141: where egd.elig_dpnt_id = p_elig_dpnt_id;
2142: --
2143: l_proc varchar2(72) := g_package||'get_elig_dpnt_rec_1';
2144: --

Line 2171: p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)

2167: -- Function to get the eligible dependent record for a covered dependent.
2168: --
2169: function get_elig_dpnt_rec(p_elig_cvrd_dpnt_id in number,
2170: p_effective_date in date,
2171: p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)
2172: return boolean is
2173: --
2174: cursor c_pdp is
2175: select egd.*

Line 2176: from ben_elig_dpnt egd,

2172: return boolean is
2173: --
2174: cursor c_pdp is
2175: select egd.*
2176: from ben_elig_dpnt egd,
2177: ben_elig_cvrd_dpnt_f pdp,
2178: ben_per_in_ler pil
2179: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
2180: and pdp.per_in_ler_id = egd.per_in_ler_id

Line 2220: p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)

2216: --
2217: function get_elig_dpnt_rec(p_dpnt_person_id in number,
2218: p_prtt_enrt_rslt_id in number,
2219: p_effective_date in date,
2220: p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)
2221: return boolean is
2222: --
2223: cursor c_pen is
2224: select egd.*

Line 2225: from ben_elig_dpnt egd,

2221: return boolean is
2222: --
2223: cursor c_pen is
2224: select egd.*
2225: from ben_elig_dpnt egd,
2226: ben_elig_cvrd_dpnt_f pdp,
2227: ben_prtt_enrt_rslt_f pen,
2228: ben_per_in_ler pil
2229: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 2281: ,p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype

2277: ,p_elig_per_id in number default null
2278: ,p_elig_per_opt_id in number default null
2279: ,p_opt_id in number default null
2280: --
2281: ,p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype
2282: )
2283: return boolean
2284: is
2285: --

Line 2292: from ben_elig_dpnt egd

2288: --
2289: cursor c_eligdpnt_exists
2290: is
2291: select null
2292: from ben_elig_dpnt egd
2293: where egd.dpnt_person_id = p_dpnt_person_id;
2294: --
2295: cursor c_oipl_max_create_dt
2296: (c_dpnt_person_id in number

Line 2303: from ben_elig_dpnt egd,

2299: ,c_pgm_id in number
2300: )
2301: is
2302: select egd.elig_dpnt_id
2303: from ben_elig_dpnt egd,
2304: ben_elig_per_opt_f epo,
2305: ben_elig_per_f pep,
2306: ben_per_in_ler pil,
2307: ben_oipl_f oipl

Line 2334: from ben_elig_dpnt egd,

2330: ,c_effective_date date
2331: )
2332: is
2333: select egd.elig_dpnt_id
2334: from ben_elig_dpnt egd,
2335: ben_per_in_ler pil,
2336: ben_elig_per_f pep
2337: where egd.dpnt_person_id = c_dpnt_person_id
2338: and egd.elig_per_opt_id is null

Line 2378: from ben_elig_dpnt egd

2374: ,c_pil_id in number
2375: )
2376: is
2377: select egd.elig_dpnt_id
2378: from ben_elig_dpnt egd
2379: where egd.elig_per_opt_id = c_elig_per_opt_id
2380: and egd.elig_per_id = c_elig_per_id
2381: and egd.dpnt_person_id = c_dpnt_person_id
2382: and egd.per_in_ler_id = c_pil_id

Line 2392: from ben_elig_dpnt egd

2388: ,c_pil_id in number
2389: )
2390: is
2391: select egd.elig_dpnt_id
2392: from ben_elig_dpnt egd
2393: where egd.elig_per_id = c_elig_per_id
2394: and egd.elig_per_opt_id is null
2395: and egd.dpnt_person_id = c_dpnt_person_id
2396: and egd.per_in_ler_id = c_pil_id;

Line 2398: l_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%type := null;

2394: and egd.elig_per_opt_id is null
2395: and egd.dpnt_person_id = c_dpnt_person_id
2396: and egd.per_in_ler_id = c_pil_id;
2397: --
2398: l_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%type := null;
2399: l_return boolean := false;
2400: l_proc varchar2(72) := g_package||'get_elig_dpnt_rec_4';
2401: --
2402: begin

Line 2718: end ben_ELIG_DPNT_api;

2714: end if;
2715: hr_utility.set_location('Leaving '||l_proc, 10);
2716: end chk_enrt_for_dpnt;
2717:
2718: end ben_ELIG_DPNT_api;