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_PIL_ASSIGNMENT_API dependencies on BEN_PIL_ASSIGNMENT

Line 1: Package Body ben_pil_assignment_api as

1: Package Body ben_pil_assignment_api as
2: /* $Header: bepsgapi.pkb 120.0 2005/09/29 06:20:39 ssarkar noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: bepsgapi.pkb 120.0 2005/09/29 06:20:39 ssarkar noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_pil_assignment_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_pil_assignment >----------------------|
10: -- ----------------------------------------------------------------------------

Line 24: l_pil_assignment_id ben_pil_assignment.pil_assignment_id%TYPE;

20: ) is
21: --
22: -- Declare cursors and local variables
23: --
24: l_pil_assignment_id ben_pil_assignment.pil_assignment_id%TYPE;
25: l_proc varchar2(72) := g_package||'create_pil_assignment';
26: l_object_version_number ben_pil_assignment.object_version_number%TYPE;
27: --
28: begin

Line 26: l_object_version_number ben_pil_assignment.object_version_number%TYPE;

22: -- Declare cursors and local variables
23: --
24: l_pil_assignment_id ben_pil_assignment.pil_assignment_id%TYPE;
25: l_proc varchar2(72) := g_package||'create_pil_assignment';
26: l_object_version_number ben_pil_assignment.object_version_number%TYPE;
27: --
28: begin
29: --
30: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 44: ben_pil_assignment_bk1.create_pil_assignment_b

40: begin
41: --
42: -- Start of API User Hook for the before hook of create_pil_assignment
43: --
44: ben_pil_assignment_bk1.create_pil_assignment_b
45: (
46: p_per_in_ler_id => p_per_in_ler_id
47: ,p_applicant_assignment_id => p_applicant_assignment_id
48: ,p_offer_assignment_id => p_offer_assignment_id

Line 76: ben_pil_assignment_bk1.create_pil_assignment_a

72: begin
73: --
74: -- Start of API User Hook for the after hook of create_pil_assignment
75: --
76: ben_pil_assignment_bk1.create_pil_assignment_a
77: (
78: p_pil_assignment_id => l_pil_assignment_id
79: ,p_per_in_ler_id => p_per_in_ler_id
80: ,p_applicant_assignment_id => p_applicant_assignment_id

Line 154: l_pil_assignment_id ben_pil_assignment.pil_assignment_id%TYPE;

150: ) is
151: --
152: -- Declare cursors and local variables
153: --
154: l_pil_assignment_id ben_pil_assignment.pil_assignment_id%TYPE;
155: l_proc varchar2(72) := g_package||'update_pil_assignment';
156: l_object_version_number ben_pil_assignment.object_version_number%TYPE;
157: --
158: begin

Line 156: l_object_version_number ben_pil_assignment.object_version_number%TYPE;

152: -- Declare cursors and local variables
153: --
154: l_pil_assignment_id ben_pil_assignment.pil_assignment_id%TYPE;
155: l_proc varchar2(72) := g_package||'update_pil_assignment';
156: l_object_version_number ben_pil_assignment.object_version_number%TYPE;
157: --
158: begin
159:
160: ----hr_utility.trace_on(null,'TRACE-file');

Line 180: ben_pil_assignment_bk2.update_pil_assignment_b

176: begin
177: --
178: -- Start of API User Hook for the before hook of update_pil_assignment
179: --
180: ben_pil_assignment_bk2.update_pil_assignment_b
181: (
182: p_pil_assignment_id => l_pil_assignment_id
183: ,p_per_in_ler_id => p_per_in_ler_id
184: ,p_applicant_assignment_id => p_applicant_assignment_id

Line 212: ben_pil_assignment_bk2.update_pil_assignment_a

208: begin
209: --
210: -- Start of API User Hook for the after hook of update_pil_assignment
211: --
212: ben_pil_assignment_bk2.update_pil_assignment_a
213: (
214: p_pil_assignment_id => l_pil_assignment_id
215: ,p_per_in_ler_id => p_per_in_ler_id
216: ,p_applicant_assignment_id => p_applicant_assignment_id

Line 281: l_object_version_number ben_pil_assignment.object_version_number%TYPE;

277: --
278: -- Declare cursors and local variables
279: --
280: l_proc varchar2(72) := g_package||'update_pil_assignment';
281: l_object_version_number ben_pil_assignment.object_version_number%TYPE;
282: --
283: begin
284: --
285: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 302: ben_pil_assignment_bk3.delete_pil_assignment_b

298: begin
299: --
300: -- Start of API User Hook for the before hook of delete_pil_assignment
301: --
302: ben_pil_assignment_bk3.delete_pil_assignment_b
303: (
304: p_pil_assignment_id => p_pil_assignment_id
305: ,p_object_version_number => p_object_version_number
306: );

Line 328: ben_pil_assignment_bk3.delete_pil_assignment_a

324: begin
325: --
326: -- Start of API User Hook for the after hook of delete_pil_assignment
327: --
328: ben_pil_assignment_bk3.delete_pil_assignment_a
329: (
330: p_pil_assignment_id => p_pil_assignment_id
331: ,p_object_version_number => l_object_version_number
332: );

Line 406: end ben_pil_assignment_api;

402: hr_utility.set_location(' Leaving:'||l_proc, 20);
403: --
404: end lck;
405: --
406: end ben_pil_assignment_api;