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_PTNL_LER_FOR_PER_API dependencies on BEN_PTNL_LER_FOR_PER

Line 1: Package Body ben_ptnl_ler_for_per_api as

1: Package Body ben_ptnl_ler_for_per_api as
2: /* $Header: bepplapi.pkb 120.0.12020000.3 2013/02/04 16:24:38 usaraswa ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: bepplapi.pkb 120.0.12020000.3 2013/02/04 16:24:38 usaraswa ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_ptnl_ler_for_per_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |------------------------< derive_PPL_statcd_dates >-----------------------|

Line 92: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;

88: ,p_called_from_form in varchar2 default 'N') is
89: --
90: -- Declare cursors and local variables
91: --
92: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;
93: l_proc varchar2(72) ;
94: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
95:
96: --

Line 94: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;

90: -- Declare cursors and local variables
91: --
92: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;
93: l_proc varchar2(72) ;
94: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
95:
96: --
97: cursor c_chk_elig_crit(c_ler_id number,c_effective_date date) is
98: select '1' from dual where exists

Line 195: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_b

191: begin
192: --
193: -- Start of API User Hook for the before hook of create_ptnl_ler_for_per
194: --
195: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_b
196: (p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
197: ,p_trgr_table_pk_id => p_trgr_table_pk_id
198: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
199: ,p_ptnl_ler_for_per_stat_cd => p_ptnl_ler_for_per_stat_cd

Line 260: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_a

256: begin
257: --
258: -- Start of API User Hook for the after hook of create_ptnl_ler_for_per
259: --
260: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_a
261: (p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
262: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
263: ,p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
264: ,p_trgr_table_pk_id => p_trgr_table_pk_id

Line 381: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;

377: ,p_effective_date in date) is
378: --
379: -- Declare cursors and local variables
380: --
381: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;
382: -- DEBUG : l_proc varchar2(72) := g_package||'create_ptnl_ler_for_per';
383: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
384: --
385: begin

Line 383: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;

379: -- Declare cursors and local variables
380: --
381: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;
382: -- DEBUG : l_proc varchar2(72) := g_package||'create_ptnl_ler_for_per';
383: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
384: --
385: begin
386: --
387: if p_validate then

Line 399: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_b

395: begin
396: --
397: -- Start of API User Hook for the before hook of create_ptnl_ler_for_per
398: --
399: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_b
400: (p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
401: ,p_trgr_table_pk_id => p_trgr_table_pk_id
402: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
403: ,p_ptnl_ler_for_per_stat_cd => p_ptnl_ler_for_per_stat_cd

Line 436: select ben_ptnl_ler_for_per_s.nextval

432: end;
433: --
434: l_object_version_number := 1;
435: --
436: select ben_ptnl_ler_for_per_s.nextval
437: into l_ptnl_ler_for_per_id
438: from sys.dual;
439: --
440: insert into ben_ptnl_ler_for_per

Line 440: insert into ben_ptnl_ler_for_per

436: select ben_ptnl_ler_for_per_s.nextval
437: into l_ptnl_ler_for_per_id
438: from sys.dual;
439: --
440: insert into ben_ptnl_ler_for_per
441: (ptnl_ler_for_per_id
442: ,csd_by_ptnl_ler_for_per_id
443: ,lf_evt_ocrd_dt
444: ,trgr_table_pk_id

Line 491: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_a

487: begin
488: --
489: -- Start of API User Hook for the after hook of create_ptnl_ler_for_per
490: --
491: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_a
492: (p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
493: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
494: ,p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
495: ,p_trgr_table_pk_id => p_trgr_table_pk_id

Line 599: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;

595: --
596: -- Declare cursors and local variables
597: --
598: l_proc varchar2(72) ;
599: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
600: --
601: begin
602: --
603: g_debug := hr_utility.debug_enabled;

Line 625: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_b

621: begin
622: --
623: -- Start of API User Hook for the before hook of update_ptnl_ler_for_per
624: --
625: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_b
626: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
627: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
628: ,p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
629: ,p_trgr_table_pk_id => p_trgr_table_pk_id

Line 691: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_a

687: begin
688: --
689: -- Start of API User Hook for the after hook of update_ptnl_ler_for_per
690: --
691: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_a
692: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
693: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
694: ,p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
695: ,p_trgr_table_pk_id => p_trgr_table_pk_id

Line 805: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;

801: --
802: -- Declare cursors and local variables
803: --
804: -- l_proc varchar2(72) := g_package||'update_ptnl_ler_for_per';
805: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
806: --
807: l_ptnl_ler_for_per_id number;
808: l_csd_by_ptnl_ler_for_per_id number;
809: l_lf_evt_ocrd_dt date;

Line 845: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_b

841: begin
842: --
843: -- Start of API User Hook for the before hook of update_ptnl_ler_for_per
844: --
845: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_b
846: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
847: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
848: ,p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
849: ,p_trgr_table_pk_id => p_trgr_table_pk_id

Line 995: update ben_ptnl_ler_for_per

991: --
992: -- Update the row using the old values for defaulted parameters and
993: -- any changed values for passed parameters.
994: --
995: update ben_ptnl_ler_for_per
996: set lf_evt_ocrd_dt = l_lf_evt_ocrd_dt,
997: trgr_table_pk_id = l_trgr_table_pk_id,
998: csd_by_ptnl_ler_for_per_id = l_csd_by_ptnl_ler_for_per_id,
999: ptnl_ler_for_per_stat_cd = l_ptnl_ler_for_per_stat_cd,

Line 1023: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_a

1019: begin
1020: --
1021: -- Start of API User Hook for the after hook of update_ptnl_ler_for_per
1022: --
1023: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_a
1024: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
1025: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
1026: ,p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
1027: ,p_trgr_table_pk_id => p_trgr_table_pk_id

Line 1105: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;

1101: --
1102: -- Declare cursors and local variables
1103: --
1104: l_proc varchar2(72);
1105: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
1106: --
1107: begin
1108: --
1109: g_debug := hr_utility.debug_enabled;

Line 1131: ben_ptnl_ler_for_per_bk3.delete_ptnl_ler_for_per_b

1127: begin
1128: --
1129: -- Start of API User Hook for the before hook of delete_ptnl_ler_for_per
1130: --
1131: ben_ptnl_ler_for_per_bk3.delete_ptnl_ler_for_per_b
1132: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
1133: ,p_object_version_number => p_object_version_number
1134: ,p_effective_date => trunc(p_effective_date));
1135: --

Line 1157: ben_ptnl_ler_for_per_bk3.delete_ptnl_ler_for_per_a

1153: begin
1154: --
1155: -- Start of API User Hook for the after hook of delete_ptnl_ler_for_per
1156: --
1157: ben_ptnl_ler_for_per_bk3.delete_ptnl_ler_for_per_a
1158: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
1159: ,p_object_version_number => l_object_version_number
1160: ,p_effective_date => trunc(p_effective_date));
1161: --

Line 1243: end ben_ptnl_ler_for_per_api;

1239: end if;
1240: --
1241: end lck;
1242: --
1243: end ben_ptnl_ler_for_per_api;