DBA Data[Home] [Help]

APPS.PER_SOLUTIONS_SELECTED_API dependencies on PER_SOLUTIONS_SELECTED

Line 1: Package Body per_solutions_selected_api as

1: Package Body per_solutions_selected_api as
2: /* $Header: pesosapi.pkb 115.2 2003/01/04 00:38:14 ndorai noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pesosapi.pkb 115.2 2003/01/04 00:38:14 ndorai noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'PER_SOLUTIONS_SELECTED_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |---------------------< CREATE_SOLUTIONS_SELECTED >------------------------|
10: -- ----------------------------------------------------------------------------

Line 24: l_solution_id PER_SOLUTIONS_SELECTED.SOLUTION_ID%TYPE;

20: -- Declare cursors and local variables
21: --
22: l_proc varchar2(72) := g_package||'CREATE_SOLUTIONS_SELECTED';
23: l_effective_date date;
24: l_solution_id PER_SOLUTIONS_SELECTED.SOLUTION_ID%TYPE;
25: l_solution_set_name PER_SOLUTIONS_SELECTED.SOLUTION_SET_NAME%TYPE;
26: l_user_id PER_SOLUTIONS_SELECTED.USER_ID%TYPE;
27: l_object_version_number PER_SOLUTIONS_SELECTED.OBJECT_VERSION_NUMBER%TYPE;
28: --

Line 25: l_solution_set_name PER_SOLUTIONS_SELECTED.SOLUTION_SET_NAME%TYPE;

21: --
22: l_proc varchar2(72) := g_package||'CREATE_SOLUTIONS_SELECTED';
23: l_effective_date date;
24: l_solution_id PER_SOLUTIONS_SELECTED.SOLUTION_ID%TYPE;
25: l_solution_set_name PER_SOLUTIONS_SELECTED.SOLUTION_SET_NAME%TYPE;
26: l_user_id PER_SOLUTIONS_SELECTED.USER_ID%TYPE;
27: l_object_version_number PER_SOLUTIONS_SELECTED.OBJECT_VERSION_NUMBER%TYPE;
28: --
29: begin

Line 26: l_user_id PER_SOLUTIONS_SELECTED.USER_ID%TYPE;

22: l_proc varchar2(72) := g_package||'CREATE_SOLUTIONS_SELECTED';
23: l_effective_date date;
24: l_solution_id PER_SOLUTIONS_SELECTED.SOLUTION_ID%TYPE;
25: l_solution_set_name PER_SOLUTIONS_SELECTED.SOLUTION_SET_NAME%TYPE;
26: l_user_id PER_SOLUTIONS_SELECTED.USER_ID%TYPE;
27: l_object_version_number PER_SOLUTIONS_SELECTED.OBJECT_VERSION_NUMBER%TYPE;
28: --
29: begin
30: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 27: l_object_version_number PER_SOLUTIONS_SELECTED.OBJECT_VERSION_NUMBER%TYPE;

23: l_effective_date date;
24: l_solution_id PER_SOLUTIONS_SELECTED.SOLUTION_ID%TYPE;
25: l_solution_set_name PER_SOLUTIONS_SELECTED.SOLUTION_SET_NAME%TYPE;
26: l_user_id PER_SOLUTIONS_SELECTED.USER_ID%TYPE;
27: l_object_version_number PER_SOLUTIONS_SELECTED.OBJECT_VERSION_NUMBER%TYPE;
28: --
29: begin
30: hr_utility.set_location('Entering:'|| l_proc, 10);
31: --

Line 47: PER_SOLUTIONS_SELECTED_BK1.CREATE_SOLUTIONS_SELECTED_b

43: --
44: -- Call Before Process User Hook
45: --
46: begin
47: PER_SOLUTIONS_SELECTED_BK1.CREATE_SOLUTIONS_SELECTED_b
48: (p_solution_id => p_solution_id
49: ,p_solution_set_name => p_solution_set_name
50: ,p_user_id => p_user_id
51: );

Line 71: PER_SOLUTIONS_SELECTED_BK1.CREATE_SOLUTIONS_SELECTED_a

67: --
68: -- Call After Process User Hook
69: --
70: begin
71: PER_SOLUTIONS_SELECTED_BK1.CREATE_SOLUTIONS_SELECTED_a
72: (p_solution_id => p_solution_id
73: ,p_solution_set_name => p_solution_set_name
74: ,p_user_id => p_user_id
75: ,p_object_version_number => p_object_version_number

Line 138: l_object_version_number PER_SOLUTIONS_SELECTED.OBJECT_VERSION_NUMBER%TYPE;

134: -- Declare cursors and local variables
135: --
136: l_proc varchar2(72) := g_package||'UPDATE_SOLUTIONS_SELECTED';
137: l_effective_date date;
138: l_object_version_number PER_SOLUTIONS_SELECTED.OBJECT_VERSION_NUMBER%TYPE;
139: --
140: begin
141: hr_utility.set_location('Entering:'|| l_proc, 10);
142: --

Line 154: PER_SOLUTIONS_SELECTED_BK2.UPDATE_SOLUTIONS_SELECTED_b

150: --
151: -- Call Before Process User Hook
152: --
153: begin
154: PER_SOLUTIONS_SELECTED_BK2.UPDATE_SOLUTIONS_SELECTED_b
155: (p_object_version_number => p_object_version_number
156: ,p_solution_id => p_solution_id
157: ,p_solution_set_name => p_solution_set_name
158: ,p_user_id => p_user_id

Line 179: PER_SOLUTIONS_SELECTED_BK2.UPDATE_SOLUTIONS_SELECTED_a

175: --
176: -- Call After Process User Hook
177: --
178: begin
179: PER_SOLUTIONS_SELECTED_BK2.UPDATE_SOLUTIONS_SELECTED_a
180: (p_object_version_number => p_object_version_number
181: ,p_solution_id => p_solution_id
182: ,p_solution_set_name => p_solution_set_name
183: ,p_user_id => p_user_id

Line 252: PER_SOLUTIONS_SELECTED_BK3.DELETE_SOLUTIONS_SELECTED_b

248: --
249: -- Call Before Process User Hook
250: --
251: begin
252: PER_SOLUTIONS_SELECTED_BK3.DELETE_SOLUTIONS_SELECTED_b
253: (p_solution_id => p_solution_id
254: ,p_solution_set_name => p_solution_set_name
255: ,p_user_id => p_user_id
256: ,p_object_version_number => p_object_version_number

Line 274: PER_SOLUTIONS_SELECTED_BK3.DELETE_SOLUTIONS_SELECTED_a

270: ,p_object_version_number => p_object_version_number
271: );
272: --
273: begin
274: PER_SOLUTIONS_SELECTED_BK3.DELETE_SOLUTIONS_SELECTED_a
275: (p_solution_id => p_solution_id
276: ,p_solution_set_name => p_solution_set_name
277: ,p_user_id => p_user_id
278: ,p_object_version_number => p_object_version_number

Line 315: end per_solutions_selected_api;

311: --
312: end DELETE_SOLUTIONS_SELECTED;
313:
314: --
315: end per_solutions_selected_api;