DBA Data[Home] [Help]

APPS.PQH_PTX_INFO_TYPES_API dependencies on PQH_PTX_INFO_TYPES

Line 1: Package Body pqh_ptx_info_types_api as

1: Package Body pqh_ptx_info_types_api as
2: /* $Header: pqptiapi.pkb 115.4 2002/12/06 18:07:04 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqptiapi.pkb 115.4 2002/12/06 18:07:04 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_ptx_info_types_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_ptx_info_type >----------------------|
10: -- ----------------------------------------------------------------------------

Line 25: l_information_type pqh_ptx_info_types.information_type%TYPE;

21: ) is
22: --
23: -- Declare cursors and local variables
24: --
25: l_information_type pqh_ptx_info_types.information_type%TYPE;
26: l_proc varchar2(72) := g_package||'create_ptx_info_type';
27: l_object_version_number pqh_ptx_info_types.object_version_number%TYPE;
28: --
29: begin

Line 27: l_object_version_number pqh_ptx_info_types.object_version_number%TYPE;

23: -- Declare cursors and local variables
24: --
25: l_information_type pqh_ptx_info_types.information_type%TYPE;
26: l_proc varchar2(72) := g_package||'create_ptx_info_type';
27: l_object_version_number pqh_ptx_info_types.object_version_number%TYPE;
28: --
29: begin
30: --
31: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 45: pqh_ptx_info_types_bk1.create_ptx_info_type_b

41: begin
42: --
43: -- Start of API User Hook for the before hook of create_ptx_info_type
44: --
45: pqh_ptx_info_types_bk1.create_ptx_info_type_b
46: (
47: p_active_inactive_flag => p_active_inactive_flag
48: ,p_description => p_description
49: ,p_multiple_occurences_flag => p_multiple_occurences_flag

Line 80: pqh_ptx_info_types_bk1.create_ptx_info_type_a

76: begin
77: --
78: -- Start of API User Hook for the after hook of create_ptx_info_type
79: --
80: pqh_ptx_info_types_bk1.create_ptx_info_type_a
81: (
82: p_information_type => l_information_type
83: ,p_active_inactive_flag => p_active_inactive_flag
84: ,p_description => p_description

Line 161: l_object_version_number pqh_ptx_info_types.object_version_number%TYPE;

157: --
158: -- Declare cursors and local variables
159: --
160: l_proc varchar2(72) := g_package||'update_ptx_info_type';
161: l_object_version_number pqh_ptx_info_types.object_version_number%TYPE;
162: --
163: begin
164: --
165: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 181: pqh_ptx_info_types_bk2.update_ptx_info_type_b

177: begin
178: --
179: -- Start of API User Hook for the before hook of update_ptx_info_type
180: --
181: pqh_ptx_info_types_bk2.update_ptx_info_type_b
182: (
183: p_information_type => p_information_type
184: ,p_active_inactive_flag => p_active_inactive_flag
185: ,p_description => p_description

Line 217: pqh_ptx_info_types_bk2.update_ptx_info_type_a

213: begin
214: --
215: -- Start of API User Hook for the after hook of update_ptx_info_type
216: --
217: pqh_ptx_info_types_bk2.update_ptx_info_type_a
218: (
219: p_information_type => p_information_type
220: ,p_active_inactive_flag => p_active_inactive_flag
221: ,p_description => p_description

Line 290: l_object_version_number pqh_ptx_info_types.object_version_number%TYPE;

286: --
287: -- Declare cursors and local variables
288: --
289: l_proc varchar2(72) := g_package||'delete_ptx_info_type';
290: l_object_version_number pqh_ptx_info_types.object_version_number%TYPE;
291: --
292: begin
293: --
294: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 311: pqh_ptx_info_types_bk3.delete_ptx_info_type_b

307: begin
308: --
309: -- Start of API User Hook for the before hook of delete_ptx_info_type
310: --
311: pqh_ptx_info_types_bk3.delete_ptx_info_type_b
312: (
313: p_information_type => p_information_type
314: ,p_object_version_number => p_object_version_number
315: ,p_effective_date => trunc(p_effective_date)

Line 339: pqh_ptx_info_types_bk3.delete_ptx_info_type_a

335: begin
336: --
337: -- Start of API User Hook for the after hook of delete_ptx_info_type
338: --
339: pqh_ptx_info_types_bk3.delete_ptx_info_type_a
340: (
341: p_information_type => p_information_type
342: ,p_object_version_number => l_object_version_number
343: ,p_effective_date => trunc(p_effective_date)

Line 419: end pqh_ptx_info_types_api;

415: hr_utility.set_location(' Leaving:'||l_proc, 70);
416: --
417: end lck;
418: --
419: end pqh_ptx_info_types_api;