APPS.PQH_ROUTING_LISTS_API dependencies on PQH_ROUTING_LISTS

Line 1: Package Body PQH_ROUTING_LISTS_api as

1: Package Body PQH_ROUTING_LISTS_api as
2: /* $Header: pqrltapi.pkb 115.6 2002/12/06 18:08:13 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqrltapi.pkb 115.6 2002/12/06 18:08:13 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' PQH_ROUTING_LISTS_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_routing_list >----------------------|
10: -- ----------------------------------------------------------------------------

Line 22: l_routing_list_id pqh_routing_lists.routing_list_id%TYPE;

18: ) is
19: --
20: -- Declare cursors and local variables
21: --
22: l_routing_list_id pqh_routing_lists.routing_list_id%TYPE;
23: l_proc varchar2(72) := g_package||'create_routing_list';
24: l_object_version_number pqh_routing_lists.object_version_number%TYPE;
25: --
26: begin

Line 24: l_object_version_number pqh_routing_lists.object_version_number%TYPE;

20: -- Declare cursors and local variables
21: --
22: l_routing_list_id pqh_routing_lists.routing_list_id%TYPE;
23: l_proc varchar2(72) := g_package||'create_routing_list';
24: l_object_version_number pqh_routing_lists.object_version_number%TYPE;
25: --
26: begin
27: --
28: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 42: PQH_ROUTING_LISTS_bk1.create_routing_list_b

38: begin
39: --
40: -- Start of API User Hook for the before hook of create_routing_list
41: --
42: PQH_ROUTING_LISTS_bk1.create_routing_list_b
43: (
44: p_routing_list_name => p_routing_list_name ,
45: p_enable_flag => p_enable_flag
46: );

Line 71: PQH_ROUTING_LISTS_bk1.create_routing_list_a

67: begin
68: --
69: -- Start of API User Hook for the after hook of create_routing_list
70: --
71: PQH_ROUTING_LISTS_bk1.create_routing_list_a
72: (
73: p_routing_list_id => l_routing_list_id
74: ,p_routing_list_name => p_routing_list_name
75: ,p_enable_flag => p_enable_flag

Line 146: l_object_version_number pqh_routing_lists.object_version_number%TYPE;

142: --
143: -- Declare cursors and local variables
144: --
145: l_proc varchar2(72) := g_package||'update_routing_list';
146: l_object_version_number pqh_routing_lists.object_version_number%TYPE;
147: --
148: begin
149: --
150: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 166: PQH_ROUTING_LISTS_bk2.update_routing_list_b

162: begin
163: --
164: -- Start of API User Hook for the before hook of update_routing_list
165: --
166: PQH_ROUTING_LISTS_bk2.update_routing_list_b
167: (
168: p_routing_list_id => p_routing_list_id
169: ,p_routing_list_name => p_routing_list_name
170: ,p_enable_flag => p_enable_flag

Line 196: PQH_ROUTING_LISTS_bk2.update_routing_list_a

192: begin
193: --
194: -- Start of API User Hook for the after hook of update_routing_list
195: --
196: PQH_ROUTING_LISTS_bk2.update_routing_list_a
197: (
198: p_routing_list_id => p_routing_list_id
199: ,p_routing_list_name => p_routing_list_name
200: ,p_enable_flag => p_enable_flag

Line 265: l_object_version_number pqh_routing_lists.object_version_number%TYPE;

261: --
262: -- Declare cursors and local variables
263: --
264: l_proc varchar2(72) := g_package||'delete_routing_list';
265: l_object_version_number pqh_routing_lists.object_version_number%TYPE;
266: --
267: cursor c1 is
268: select routing_list_member_id,object_version_number
269: from pqh_routing_list_members

Line 291: PQH_ROUTING_LISTS_bk3.delete_routing_list_b

287: begin
288: --
289: -- Start of API User Hook for the before hook of delete_routing_list
290: --
291: PQH_ROUTING_LISTS_bk3.delete_routing_list_b
292: (
293: p_routing_list_id => p_routing_list_id
294: ,p_object_version_number => p_object_version_number
295: );

Line 327: PQH_ROUTING_LISTS_bk3.delete_routing_list_a

323: begin
324: --
325: -- Start of API User Hook for the after hook of delete_routing_list
326: --
327: PQH_ROUTING_LISTS_bk3.delete_routing_list_a
328: (
329: p_routing_list_id => p_routing_list_id
330: ,p_object_version_number => l_object_version_number
331: );

Line 405: end PQH_ROUTING_LISTS_api;

401: hr_utility.set_location(' Leaving:'||l_proc, 70);
402: --
403: end lck;
404: --
405: end PQH_ROUTING_LISTS_api;