DBA Data[Home] [Help]

APPS.PQH_COPY_ENTITY_PREFS_API dependencies on PQH_COPY_ENTITY_PREFS

Line 1: Package Body pqh_copy_entity_prefs_api as

1: Package Body pqh_copy_entity_prefs_api as
2: /* $Header: pqcepapi.pkb 115.3 2002/12/05 19:31:15 rpasapul ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqcepapi.pkb 115.3 2002/12/05 19:31:15 rpasapul ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_copy_entity_prefs_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_copy_entity_pref >----------------------|
10: -- ----------------------------------------------------------------------------

Line 24: l_copy_entity_pref_id pqh_copy_entity_prefs.copy_entity_pref_id%TYPE;

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

Line 26: l_object_version_number pqh_copy_entity_prefs.object_version_number%TYPE;

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

Line 44: pqh_copy_entity_prefs_bk1.create_copy_entity_pref_b

40: begin
41: --
42: -- Start of API User Hook for the before hook of create_copy_entity_prefs
43: --
44: pqh_copy_entity_prefs_bk1.create_copy_entity_pref_b
45: (
46: p_table_route_id => p_table_route_id
47: ,p_copy_entity_txn_id => p_copy_entity_txn_id
48: ,p_select_flag => p_select_flag

Line 77: pqh_copy_entity_prefs_bk1.create_copy_entity_pref_a

73: begin
74: --
75: -- Start of API User Hook for the after hook of create_copy_entity_prefs
76: --
77: pqh_copy_entity_prefs_bk1.create_copy_entity_pref_a
78: (
79: p_copy_entity_pref_id => l_copy_entity_pref_id
80: ,p_table_route_id => p_table_route_id
81: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 156: l_object_version_number pqh_copy_entity_prefs.object_version_number%TYPE;

152: --
153: -- Declare cursors and local variables
154: --
155: l_proc varchar2(72) := g_package||'update_copy_entity_pref';
156: l_object_version_number pqh_copy_entity_prefs.object_version_number%TYPE;
157: --
158: begin
159: --
160: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 176: pqh_copy_entity_prefs_bk2.update_copy_entity_pref_b

172: begin
173: --
174: -- Start of API User Hook for the before hook of update_copy_entity_prefs
175: --
176: pqh_copy_entity_prefs_bk2.update_copy_entity_pref_b
177: (
178: p_copy_entity_pref_id => p_copy_entity_pref_id
179: ,p_table_route_id => p_table_route_id
180: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 210: pqh_copy_entity_prefs_bk2.update_copy_entity_pref_a

206: begin
207: --
208: -- Start of API User Hook for the after hook of update_copy_entity_prefs
209: --
210: pqh_copy_entity_prefs_bk2.update_copy_entity_pref_a
211: (
212: p_copy_entity_pref_id => p_copy_entity_pref_id
213: ,p_table_route_id => p_table_route_id
214: ,p_copy_entity_txn_id => p_copy_entity_txn_id

Line 282: l_object_version_number pqh_copy_entity_prefs.object_version_number%TYPE;

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

Line 303: pqh_copy_entity_prefs_bk3.delete_copy_entity_pref_b

299: begin
300: --
301: -- Start of API User Hook for the before hook of delete_copy_entity_prefs
302: --
303: pqh_copy_entity_prefs_bk3.delete_copy_entity_pref_b
304: (
305: p_copy_entity_pref_id => p_copy_entity_pref_id
306: ,p_object_version_number => p_object_version_number
307: ,p_effective_date => trunc(p_effective_date)

Line 331: pqh_copy_entity_prefs_bk3.delete_copy_entity_pref_a

327: begin
328: --
329: -- Start of API User Hook for the after hook of delete_copy_entity_prefs
330: --
331: pqh_copy_entity_prefs_bk3.delete_copy_entity_pref_a
332: (
333: p_copy_entity_pref_id => p_copy_entity_pref_id
334: ,p_object_version_number => l_object_version_number
335: ,p_effective_date => trunc(p_effective_date)

Line 410: end pqh_copy_entity_prefs_api;

406: hr_utility.set_location(' Leaving:'||l_proc, 70);
407: --
408: end lck;
409: --
410: end pqh_copy_entity_prefs_api;