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_ELIGIBLE_PERSON_PERF_API dependencies on BEN_ELIG_PER_F

Line 129: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;

125: l_pepinsplip_score_tab ben_evaluate_elig_profiles.scoreTab;
126: --
127: -- Declare cursors and local variables
128: --
129: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
130: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
131: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
132: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
133: --

Line 130: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;

126: --
127: -- Declare cursors and local variables
128: --
129: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
130: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
131: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
132: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
133: --
134: l_created_by ben_elig_per_f.created_by%TYPE;

Line 131: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;

127: -- Declare cursors and local variables
128: --
129: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
130: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
131: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
132: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
133: --
134: l_created_by ben_elig_per_f.created_by%TYPE;
135: l_creation_date ben_elig_per_f.creation_date%TYPE;

Line 132: l_object_version_number ben_elig_per_f.object_version_number%TYPE;

128: --
129: l_elig_per_id ben_elig_per_f.elig_per_id%TYPE;
130: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
131: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
132: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
133: --
134: l_created_by ben_elig_per_f.created_by%TYPE;
135: l_creation_date ben_elig_per_f.creation_date%TYPE;
136: l_last_update_date ben_elig_per_f.last_update_date%TYPE;

Line 134: l_created_by ben_elig_per_f.created_by%TYPE;

130: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
131: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
132: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
133: --
134: l_created_by ben_elig_per_f.created_by%TYPE;
135: l_creation_date ben_elig_per_f.creation_date%TYPE;
136: l_last_update_date ben_elig_per_f.last_update_date%TYPE;
137: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
138: l_last_update_login ben_elig_per_f.last_update_login%TYPE;

Line 135: l_creation_date ben_elig_per_f.creation_date%TYPE;

131: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
132: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
133: --
134: l_created_by ben_elig_per_f.created_by%TYPE;
135: l_creation_date ben_elig_per_f.creation_date%TYPE;
136: l_last_update_date ben_elig_per_f.last_update_date%TYPE;
137: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
138: l_last_update_login ben_elig_per_f.last_update_login%TYPE;
139: --

Line 136: l_last_update_date ben_elig_per_f.last_update_date%TYPE;

132: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
133: --
134: l_created_by ben_elig_per_f.created_by%TYPE;
135: l_creation_date ben_elig_per_f.creation_date%TYPE;
136: l_last_update_date ben_elig_per_f.last_update_date%TYPE;
137: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
138: l_last_update_login ben_elig_per_f.last_update_login%TYPE;
139: --
140: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;

Line 137: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;

133: --
134: l_created_by ben_elig_per_f.created_by%TYPE;
135: l_creation_date ben_elig_per_f.creation_date%TYPE;
136: l_last_update_date ben_elig_per_f.last_update_date%TYPE;
137: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
138: l_last_update_login ben_elig_per_f.last_update_login%TYPE;
139: --
140: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
141: l_dummy_pep_id number;

Line 138: l_last_update_login ben_elig_per_f.last_update_login%TYPE;

134: l_created_by ben_elig_per_f.created_by%TYPE;
135: l_creation_date ben_elig_per_f.creation_date%TYPE;
136: l_last_update_date ben_elig_per_f.last_update_date%TYPE;
137: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
138: l_last_update_login ben_elig_per_f.last_update_login%TYPE;
139: --
140: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
141: l_dummy_pep_id number;
142: l_dummy_esd date;

Line 387: -- Since creation of BEN_ELIG_PER_F at PLIP level is DEFERRED until we create BEN_ELIG_PER_F

383: ,p_defer => false
384: );
385: --
386: -- Bug 4438430
387: -- Since creation of BEN_ELIG_PER_F at PLIP level is DEFERRED until we create BEN_ELIG_PER_F
388: -- record at PLN level, creation of BEN_ELIG_SCRE_WTG_F (PLIP) was also deferred. So now we create
389: -- BEN_ELIG_SCRE_WTG_F record for ELPROs at PLIP level.
390: -- In BEN_ELIG_SCRE_WTG_API.LOAD_SCORE_WEIGHT we store the P_SCORE_TAB in global table G_PEPINSPLIP
391: --

Line 550: -- Insert the row into: ben_elig_per_f

546: l_object_version_number := 1;
547: --
548: ben_pep_shd.g_api_dml := true; -- Set the api dml status
549: --
550: -- Insert the row into: ben_elig_per_f
551: --
552: hr_utility.set_location('Insert: '||l_proc, 5);
553: insert into ben_elig_per_f
554: (

Line 553: insert into ben_elig_per_f

549: --
550: -- Insert the row into: ben_elig_per_f
551: --
552: hr_utility.set_location('Insert: '||l_proc, 5);
553: insert into ben_elig_per_f
554: (
555: elig_per_id,
556: effective_start_date,
557: effective_end_date,

Line 661: ben_elig_per_f_s.nextval,

657: last_update_login
658: )
659: Values
660: (
661: ben_elig_per_f_s.nextval,
662: l_effective_start_date,
663: l_effective_end_date,
664: p_business_group_id,
665: p_pl_id,

Line 1353: from ben_elig_per_f

1349: program_application_id,
1350: program_id,
1351: program_update_date,
1352: object_version_number
1353: from ben_elig_per_f
1354: where elig_per_id = p_elig_per_id
1355: and p_effective_date
1356: between effective_start_date and effective_end_date;
1357: --

Line 1423: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_f');

1419: -- The object is locked therefore we need to supply a meaningful
1420: -- error message.
1421: --
1422: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
1423: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_f');
1424: fnd_message.raise_error;
1425: --
1426: When l_object_invalid then
1427: --

Line 1431: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_f');

1427: --
1428: -- The object doesn't exist or is invalid
1429: --
1430: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
1431: fnd_message.set_token('TABLE_NAME', 'ben_elig_per_f');
1432: fnd_message.raise_error;
1433: --
1434: End perf_lck;
1435: --

Line 1553: l_object_version_number ben_elig_per_f.object_version_number%TYPE;

1549: --
1550: l_proc varchar2(72) := g_package||'update_perf_Eligible_Person';
1551: --
1552: l_rec ben_pep_shd.g_rec_type;
1553: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1554: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1555: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1556: --
1557: l_validation_start_date date;

Line 1554: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;

1550: l_proc varchar2(72) := g_package||'update_perf_Eligible_Person';
1551: --
1552: l_rec ben_pep_shd.g_rec_type;
1553: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1554: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1555: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1556: --
1557: l_validation_start_date date;
1558: l_validation_end_date date;

Line 1555: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;

1551: --
1552: l_rec ben_pep_shd.g_rec_type;
1553: l_object_version_number ben_elig_per_f.object_version_number%TYPE;
1554: l_effective_start_date ben_elig_per_f.effective_start_date%TYPE;
1555: l_effective_end_date ben_elig_per_f.effective_end_date%TYPE;
1556: --
1557: l_validation_start_date date;
1558: l_validation_end_date date;
1559: l_dummy_version_number number;

Line 1678: from ben_elig_per_f

1674: program_application_id,
1675: program_id,
1676: program_update_date,
1677: object_version_number
1678: from ben_elig_per_f
1679: where elig_per_id = p_elig_per_id
1680: and p_effective_date
1681: between effective_start_date and effective_end_date
1682: for update nowait;

Line 1688: from ben_elig_per_f t

1684: Cursor C_Sel1
1685: Is
1686: select t.created_by,
1687: t.creation_date
1688: from ben_elig_per_f t
1689: where t.elig_per_id = p_elig_per_id
1690: and t.effective_start_date =
1691: ben_pep_shd.g_old_rec.effective_start_date
1692: and t.effective_end_date = (l_validation_start_date - 1);

Line 1701: from ben_elig_per_f pep

1697: )
1698: is
1699: select pep.effective_start_date,
1700: pep.effective_end_date
1701: from ben_elig_per_f pep
1702: where pep.elig_per_id = c_pep_id
1703: and c_eff_date
1704: between pep.effective_start_date and pep.effective_end_date;
1705: --

Line 1711: from ben_elig_per_f pep

1707: (c_pep_id number
1708: )
1709: is
1710: select nvl(max(pep.object_version_number),0) + 1
1711: from ben_elig_per_f pep
1712: where pep.elig_per_id = c_pep_id;
1713: --
1714: cursor c_plip
1715: (p_elig_per_id number, cv_pgm_id number) is

Line 1718: ben_elig_per_f pep

1714: cursor c_plip
1715: (p_elig_per_id number, cv_pgm_id number) is
1716: select cpp.plip_id
1717: from ben_plip_f cpp,
1718: ben_elig_per_f pep
1719: where cpp.pl_id = pep.pl_id
1720: and pep.elig_per_id = p_elig_per_id
1721: and cpp.pgm_id = cv_pgm_id /* Bug 5098907 */
1722: and p_effective_date

Line 2254: update ben_elig_per_f t

2250: --
2251: -- Update the specified datetrack row setting the effective
2252: -- end date to the specified new effective end date.
2253: --
2254: update ben_elig_per_f t
2255: set t.effective_end_date = l_validation_start_date - 1,
2256: t.object_version_number = l_object_version_number
2257: where t.elig_per_id = p_elig_per_id
2258: and p_effective_date

Line 2276: delete from ben_elig_per_f

2272: --
2273: -- Delete the where the effective start date is equal
2274: -- to the validation end date.
2275: --
2276: delete from ben_elig_per_f
2277: where elig_per_id = p_elig_per_id
2278: and effective_start_date = l_validation_start_date;
2279: --
2280: ben_pep_shd.g_api_dml := false; -- Unset the api dml status

Line 2288: delete from ben_elig_per_f

2284: --
2285: -- Delete the row(s) where the effective start date is greater than
2286: -- or equal to the validation start date.
2287: --
2288: delete from ben_elig_per_f
2289: where elig_per_id = p_elig_per_id
2290: and effective_start_date >= l_validation_start_date;
2291: --
2292: ben_pep_shd.g_api_dml := false; -- Unset the api dml status

Line 2348: -- Insert the row into: ben_elig_per_f

2344: End If;
2345: --
2346: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2347: --
2348: -- Insert the row into: ben_elig_per_f
2349: --
2350: hr_utility.set_location('Ins PEP:'||l_proc, 5);
2351: insert into ben_elig_per_f
2352: (

Line 2351: insert into ben_elig_per_f

2347: --
2348: -- Insert the row into: ben_elig_per_f
2349: --
2350: hr_utility.set_location('Ins PEP:'||l_proc, 5);
2351: insert into ben_elig_per_f
2352: (
2353: elig_per_id,
2354: effective_start_date,
2355: effective_end_date,

Line 2589: -- Update the ben_elig_per_f Row

2585: close c_getovn;
2586: --
2587: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2588: --
2589: -- Update the ben_elig_per_f Row
2590: --
2591: update ben_elig_per_f
2592: set
2593: elig_per_id = l_rec.elig_per_id,

Line 2591: update ben_elig_per_f

2587: ben_pep_shd.g_api_dml := true; -- Set the api dml status
2588: --
2589: -- Update the ben_elig_per_f Row
2590: --
2591: update ben_elig_per_f
2592: set
2593: elig_per_id = l_rec.elig_per_id,
2594: business_group_id = l_rec.business_group_id,
2595: pl_id = l_rec.pl_id,

Line 3035: -- Insert the row into: ben_elig_per_f

3031: Open C_Sel1;
3032: Fetch C_Sel1 Into l_elig_per_opt_id;
3033: Close C_Sel1;
3034: --
3035: -- Insert the row into: ben_elig_per_f
3036: --
3037: hr_utility.set_location('Insert: '||l_proc, 5);
3038: hr_utility.set_location('Ins EPO:'||l_proc, 5);
3039: insert into ben_elig_per_opt_f

Line 3461: p_parent_table_name1 => 'ben_elig_per_f',

3457: p_base_table_name => 'ben_elig_per_opt_f',
3458: p_base_key_column => 'elig_per_opt_id',
3459: p_base_key_value => p_elig_per_opt_id,
3460: /*
3461: p_parent_table_name1 => 'ben_elig_per_f',
3462: p_parent_key_column1 => 'elig_per_id',
3463: p_parent_key_value1 => g_old_rec.elig_per_id,
3464: */
3465: p_parent_table_name2 => 'ben_opt_f',