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 2005/05/28 10:58:30 appldev noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: bepplapi.pkb 120.0 2005/05/28 10:58:30 appldev noship $ */
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 91: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;

87: ,p_effective_date in date) is
88: --
89: -- Declare cursors and local variables
90: --
91: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;
92: l_proc varchar2(72) ;
93: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
94: --
95: begin

Line 93: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;

89: -- Declare cursors and local variables
90: --
91: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;
92: l_proc varchar2(72) ;
93: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
94: --
95: begin
96: --
97: g_debug := hr_utility.debug_enabled;

Line 117: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_b

113: begin
114: --
115: -- Start of API User Hook for the before hook of create_ptnl_ler_for_per
116: --
117: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_b
118: (p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
119: ,p_trgr_table_pk_id => p_trgr_table_pk_id
120: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
121: ,p_ptnl_ler_for_per_stat_cd => p_ptnl_ler_for_per_stat_cd

Line 181: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_a

177: begin
178: --
179: -- Start of API User Hook for the after hook of create_ptnl_ler_for_per
180: --
181: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_a
182: (p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
183: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
184: ,p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
185: ,p_trgr_table_pk_id => p_trgr_table_pk_id

Line 299: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;

295: ,p_effective_date in date) is
296: --
297: -- Declare cursors and local variables
298: --
299: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;
300: -- DEBUG : l_proc varchar2(72) := g_package||'create_ptnl_ler_for_per';
301: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
302: --
303: begin

Line 301: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;

297: -- Declare cursors and local variables
298: --
299: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;
300: -- DEBUG : l_proc varchar2(72) := g_package||'create_ptnl_ler_for_per';
301: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
302: --
303: begin
304: --
305: if p_validate then

Line 317: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_b

313: begin
314: --
315: -- Start of API User Hook for the before hook of create_ptnl_ler_for_per
316: --
317: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_b
318: (p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
319: ,p_trgr_table_pk_id => p_trgr_table_pk_id
320: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
321: ,p_ptnl_ler_for_per_stat_cd => p_ptnl_ler_for_per_stat_cd

Line 354: select ben_ptnl_ler_for_per_s.nextval

350: end;
351: --
352: l_object_version_number := 1;
353: --
354: select ben_ptnl_ler_for_per_s.nextval
355: into l_ptnl_ler_for_per_id
356: from sys.dual;
357: --
358: insert into ben_ptnl_ler_for_per

Line 358: insert into ben_ptnl_ler_for_per

354: select ben_ptnl_ler_for_per_s.nextval
355: into l_ptnl_ler_for_per_id
356: from sys.dual;
357: --
358: insert into ben_ptnl_ler_for_per
359: (ptnl_ler_for_per_id
360: ,csd_by_ptnl_ler_for_per_id
361: ,lf_evt_ocrd_dt
362: ,trgr_table_pk_id

Line 409: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_a

405: begin
406: --
407: -- Start of API User Hook for the after hook of create_ptnl_ler_for_per
408: --
409: ben_ptnl_ler_for_per_bk1.create_ptnl_ler_for_per_a
410: (p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
411: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
412: ,p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
413: ,p_trgr_table_pk_id => p_trgr_table_pk_id

Line 517: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;

513: --
514: -- Declare cursors and local variables
515: --
516: l_proc varchar2(72) ;
517: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
518: --
519: begin
520: --
521: g_debug := hr_utility.debug_enabled;

Line 543: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_b

539: begin
540: --
541: -- Start of API User Hook for the before hook of update_ptnl_ler_for_per
542: --
543: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_b
544: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
545: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
546: ,p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
547: ,p_trgr_table_pk_id => p_trgr_table_pk_id

Line 609: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_a

605: begin
606: --
607: -- Start of API User Hook for the after hook of update_ptnl_ler_for_per
608: --
609: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_a
610: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
611: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
612: ,p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
613: ,p_trgr_table_pk_id => p_trgr_table_pk_id

Line 723: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;

719: --
720: -- Declare cursors and local variables
721: --
722: -- l_proc varchar2(72) := g_package||'update_ptnl_ler_for_per';
723: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
724: --
725: l_ptnl_ler_for_per_id number;
726: l_csd_by_ptnl_ler_for_per_id number;
727: l_lf_evt_ocrd_dt date;

Line 763: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_b

759: begin
760: --
761: -- Start of API User Hook for the before hook of update_ptnl_ler_for_per
762: --
763: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_b
764: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
765: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
766: ,p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
767: ,p_trgr_table_pk_id => p_trgr_table_pk_id

Line 913: update ben_ptnl_ler_for_per

909: --
910: -- Update the row using the old values for defaulted parameters and
911: -- any changed values for passed parameters.
912: --
913: update ben_ptnl_ler_for_per
914: set lf_evt_ocrd_dt = l_lf_evt_ocrd_dt,
915: trgr_table_pk_id = l_trgr_table_pk_id,
916: csd_by_ptnl_ler_for_per_id = l_csd_by_ptnl_ler_for_per_id,
917: ptnl_ler_for_per_stat_cd = l_ptnl_ler_for_per_stat_cd,

Line 941: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_a

937: begin
938: --
939: -- Start of API User Hook for the after hook of update_ptnl_ler_for_per
940: --
941: ben_ptnl_ler_for_per_bk2.update_ptnl_ler_for_per_a
942: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
943: ,p_csd_by_ptnl_ler_for_per_id => p_csd_by_ptnl_ler_for_per_id
944: ,p_lf_evt_ocrd_dt => trunc(p_lf_evt_ocrd_dt)
945: ,p_trgr_table_pk_id => p_trgr_table_pk_id

Line 1023: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;

1019: --
1020: -- Declare cursors and local variables
1021: --
1022: l_proc varchar2(72);
1023: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
1024: --
1025: begin
1026: --
1027: g_debug := hr_utility.debug_enabled;

Line 1049: ben_ptnl_ler_for_per_bk3.delete_ptnl_ler_for_per_b

1045: begin
1046: --
1047: -- Start of API User Hook for the before hook of delete_ptnl_ler_for_per
1048: --
1049: ben_ptnl_ler_for_per_bk3.delete_ptnl_ler_for_per_b
1050: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
1051: ,p_object_version_number => p_object_version_number
1052: ,p_effective_date => trunc(p_effective_date));
1053: --

Line 1075: ben_ptnl_ler_for_per_bk3.delete_ptnl_ler_for_per_a

1071: begin
1072: --
1073: -- Start of API User Hook for the after hook of delete_ptnl_ler_for_per
1074: --
1075: ben_ptnl_ler_for_per_bk3.delete_ptnl_ler_for_per_a
1076: (p_ptnl_ler_for_per_id => p_ptnl_ler_for_per_id
1077: ,p_object_version_number => l_object_version_number
1078: ,p_effective_date => trunc(p_effective_date));
1079: --

Line 1161: end ben_ptnl_ler_for_per_api;

1157: end if;
1158: --
1159: end lck;
1160: --
1161: end ben_ptnl_ler_for_per_api;