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 2006/11/02 15:44:27 rgajula noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: beegdapi.pkb 120.11 2006/11/02 15:44:27 rgajula noship $ */
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 1659: ben_elig_dpnt_api.update_elig_dpnt(

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

Line 1815: ben_elig_dpnt_api.update_elig_dpnt(

1811: p_program_id => fnd_global.conc_program_id,
1812: p_request_id => fnd_global.conc_request_id,
1813: p_program_update_date => sysdate);
1814: --
1815: ben_elig_dpnt_api.update_elig_dpnt(
1816: p_elig_dpnt_id => p_elig_dpnt_id,
1817: p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id,
1818: p_effective_date => p_effective_date,
1819: p_business_group_id => p_business_group_id,

Line 2128: p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)

2124: --
2125: -- Function to get the eligible dependent record.
2126: --
2127: function get_elig_dpnt_rec(p_elig_dpnt_id in number,
2128: p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)
2129: return boolean is
2130: --
2131: cursor c_egd is
2132: select egd.*

Line 2133: from ben_elig_dpnt egd

2129: return boolean is
2130: --
2131: cursor c_egd is
2132: select egd.*
2133: from ben_elig_dpnt egd
2134: where egd.elig_dpnt_id = p_elig_dpnt_id;
2135: --
2136: l_proc varchar2(72) := g_package||'get_elig_dpnt_rec_1';
2137: --

Line 2164: p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)

2160: -- Function to get the eligible dependent record for a covered dependent.
2161: --
2162: function get_elig_dpnt_rec(p_elig_cvrd_dpnt_id in number,
2163: p_effective_date in date,
2164: p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)
2165: return boolean is
2166: --
2167: cursor c_pdp is
2168: select egd.*

Line 2169: from ben_elig_dpnt egd,

2165: return boolean is
2166: --
2167: cursor c_pdp is
2168: select egd.*
2169: from ben_elig_dpnt egd,
2170: ben_elig_cvrd_dpnt_f pdp,
2171: ben_per_in_ler pil
2172: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
2173: and pdp.per_in_ler_id = egd.per_in_ler_id

Line 2213: p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)

2209: --
2210: function get_elig_dpnt_rec(p_dpnt_person_id in number,
2211: p_prtt_enrt_rslt_id in number,
2212: p_effective_date in date,
2213: p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype)
2214: return boolean is
2215: --
2216: cursor c_pen is
2217: select egd.*

Line 2218: from ben_elig_dpnt egd,

2214: return boolean is
2215: --
2216: cursor c_pen is
2217: select egd.*
2218: from ben_elig_dpnt egd,
2219: ben_elig_cvrd_dpnt_f pdp,
2220: ben_prtt_enrt_rslt_f pen,
2221: ben_per_in_ler pil
2222: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 2274: ,p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype

2270: ,p_elig_per_id in number default null
2271: ,p_elig_per_opt_id in number default null
2272: ,p_opt_id in number default null
2273: --
2274: ,p_elig_dpnt_rec out nocopy ben_elig_dpnt%rowtype
2275: )
2276: return boolean
2277: is
2278: --

Line 2285: from ben_elig_dpnt egd

2281: --
2282: cursor c_eligdpnt_exists
2283: is
2284: select null
2285: from ben_elig_dpnt egd
2286: where egd.dpnt_person_id = p_dpnt_person_id;
2287: --
2288: cursor c_oipl_max_create_dt
2289: (c_dpnt_person_id in number

Line 2296: from ben_elig_dpnt egd,

2292: ,c_pgm_id in number
2293: )
2294: is
2295: select egd.elig_dpnt_id
2296: from ben_elig_dpnt egd,
2297: ben_elig_per_opt_f epo,
2298: ben_elig_per_f pep,
2299: ben_per_in_ler pil,
2300: ben_oipl_f oipl

Line 2327: from ben_elig_dpnt egd,

2323: ,c_effective_date date
2324: )
2325: is
2326: select egd.elig_dpnt_id
2327: from ben_elig_dpnt egd,
2328: ben_per_in_ler pil,
2329: ben_elig_per_f pep
2330: where egd.dpnt_person_id = c_dpnt_person_id
2331: and egd.elig_per_opt_id is null

Line 2371: from ben_elig_dpnt egd

2367: ,c_pil_id in number
2368: )
2369: is
2370: select egd.elig_dpnt_id
2371: from ben_elig_dpnt egd
2372: where egd.elig_per_opt_id = c_elig_per_opt_id
2373: and egd.elig_per_id = c_elig_per_id
2374: and egd.dpnt_person_id = c_dpnt_person_id
2375: and egd.per_in_ler_id = c_pil_id

Line 2385: from ben_elig_dpnt egd

2381: ,c_pil_id in number
2382: )
2383: is
2384: select egd.elig_dpnt_id
2385: from ben_elig_dpnt egd
2386: where egd.elig_per_id = c_elig_per_id
2387: and egd.elig_per_opt_id is null
2388: and egd.dpnt_person_id = c_dpnt_person_id
2389: and egd.per_in_ler_id = c_pil_id;

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

2387: and egd.elig_per_opt_id is null
2388: and egd.dpnt_person_id = c_dpnt_person_id
2389: and egd.per_in_ler_id = c_pil_id;
2390: --
2391: l_elig_dpnt_id ben_elig_dpnt.elig_dpnt_id%type := null;
2392: l_return boolean := false;
2393: l_proc varchar2(72) := g_package||'get_elig_dpnt_rec_4';
2394: --
2395: begin

Line 2653: end ben_ELIG_DPNT_api;

2649: p_lookup_code => l_crt_ordr_typ_cd
2650: );
2651: end get_crt_ordr_typ;
2652: --
2653: end ben_ELIG_DPNT_api;