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.PQH_ROUTING_LIST_MEMBERS_API dependencies on PQH_ROUTING_LIST_MEMBERS

Line 1: Package Body PQH_ROUTING_LIST_MEMBERS_api as

1: Package Body PQH_ROUTING_LIST_MEMBERS_api as
2: /* $Header: pqrlmapi.pkb 115.5 2002/12/06 18:08:08 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

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

Line 27: l_routing_list_member_id pqh_routing_list_members.routing_list_member_id%TYPE;

23: ) is
24: --
25: -- Declare cursors and local variables
26: --
27: l_routing_list_member_id pqh_routing_list_members.routing_list_member_id%TYPE;
28: l_proc varchar2(72) := g_package||'create_routing_list_member';
29: l_object_version_number pqh_routing_list_members.object_version_number%TYPE;
30: --
31: begin

Line 29: l_object_version_number pqh_routing_list_members.object_version_number%TYPE;

25: -- Declare cursors and local variables
26: --
27: l_routing_list_member_id pqh_routing_list_members.routing_list_member_id%TYPE;
28: l_proc varchar2(72) := g_package||'create_routing_list_member';
29: l_object_version_number pqh_routing_list_members.object_version_number%TYPE;
30: --
31: begin
32: --
33: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 47: PQH_ROUTING_LIST_MEMBERS_bk1.create_routing_list_member_b

43: begin
44: --
45: -- Start of API User Hook for the before hook of create_routing_list_member
46: --
47: PQH_ROUTING_LIST_MEMBERS_bk1.create_routing_list_member_b
48: (
49: p_role_id => p_role_id
50: ,p_routing_list_id => p_routing_list_id
51: ,p_seq_no => p_seq_no

Line 86: PQH_ROUTING_LIST_MEMBERS_bk1.create_routing_list_member_a

82: begin
83: --
84: -- Start of API User Hook for the after hook of create_routing_list_member
85: --
86: PQH_ROUTING_LIST_MEMBERS_bk1.create_routing_list_member_a
87: (
88: p_role_id => p_role_id
89: ,p_routing_list_id => p_routing_list_id
90: ,p_routing_list_member_id => l_routing_list_member_id

Line 171: l_object_version_number pqh_routing_list_members.object_version_number%TYPE;

167: --
168: -- Declare cursors and local variables
169: --
170: l_proc varchar2(72) := g_package||'update_routing_list_member';
171: l_object_version_number pqh_routing_list_members.object_version_number%TYPE;
172: --
173: begin
174: --
175: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 191: PQH_ROUTING_LIST_MEMBERS_bk2.update_routing_list_member_b

187: begin
188: --
189: -- Start of API User Hook for the before hook of update_routing_list_member
190: --
191: PQH_ROUTING_LIST_MEMBERS_bk2.update_routing_list_member_b
192: (
193: p_role_id => p_role_id
194: ,p_routing_list_id => p_routing_list_id
195: ,p_routing_list_member_id => p_routing_list_member_id

Line 231: PQH_ROUTING_LIST_MEMBERS_bk2.update_routing_list_member_a

227: begin
228: --
229: -- Start of API User Hook for the after hook of update_routing_list_member
230: --
231: PQH_ROUTING_LIST_MEMBERS_bk2.update_routing_list_member_a
232: (
233: p_role_id => p_role_id
234: ,p_routing_list_id => p_routing_list_id
235: ,p_routing_list_member_id => p_routing_list_member_id

Line 306: l_object_version_number pqh_routing_list_members.object_version_number%TYPE;

302: --
303: -- Declare cursors and local variables
304: --
305: l_proc varchar2(72) := g_package||'delete_routing_list_member';
306: l_object_version_number pqh_routing_list_members.object_version_number%TYPE;
307: --
308: begin
309: --
310: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 327: PQH_ROUTING_LIST_MEMBERS_bk3.delete_routing_list_member_b

323: begin
324: --
325: -- Start of API User Hook for the before hook of delete_routing_list_member
326: --
327: PQH_ROUTING_LIST_MEMBERS_bk3.delete_routing_list_member_b
328: (
329: p_routing_list_member_id => p_routing_list_member_id
330: ,p_object_version_number => p_object_version_number
331: ,p_effective_date => trunc(p_effective_date)

Line 355: PQH_ROUTING_LIST_MEMBERS_bk3.delete_routing_list_member_a

351: begin
352: --
353: -- Start of API User Hook for the after hook of delete_routing_list_member
354: --
355: PQH_ROUTING_LIST_MEMBERS_bk3.delete_routing_list_member_a
356: (
357: p_routing_list_member_id => p_routing_list_member_id
358: ,p_object_version_number => l_object_version_number
359: ,p_effective_date => trunc(p_effective_date)

Line 434: end PQH_ROUTING_LIST_MEMBERS_api;

430: hr_utility.set_location(' Leaving:'||l_proc, 70);
431: --
432: end lck;
433: --
434: end PQH_ROUTING_LIST_MEMBERS_api;