[Home] [Help]
1: Package Body pqh_transaction_templates_api as
2: /* $Header: pqttmapi.pkb 115.4 2002/12/06 23:49:23 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: pqttmapi.pkb 115.4 2002/12/06 23:49:23 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_transaction_templates_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_transaction_template >----------------------|
10: -- ----------------------------------------------------------------------------
21: ) is
22: --
23: -- Declare cursors and local variables
24: --
25: l_transaction_template_id pqh_transaction_templates.transaction_template_id%TYPE;
26: l_proc varchar2(72) := g_package||'create_transaction_template';
27: l_object_version_number pqh_transaction_templates.object_version_number%TYPE;
28: --
29: begin
23: -- Declare cursors and local variables
24: --
25: l_transaction_template_id pqh_transaction_templates.transaction_template_id%TYPE;
26: l_proc varchar2(72) := g_package||'create_transaction_template';
27: l_object_version_number pqh_transaction_templates.object_version_number%TYPE;
28: --
29: begin
30: --
31: hr_utility.set_location('Entering:'|| l_proc, 10);
41: begin
42: --
43: -- Start of API User Hook for the before hook of create_transaction_template
44: --
45: pqh_transaction_templates_bk1.create_transaction_template_b
46: (
47: p_enable_flag => p_enable_flag
48: ,p_template_id => p_template_id
49: ,p_transaction_id => p_transaction_id
76: begin
77: --
78: -- Start of API User Hook for the after hook of create_transaction_template
79: --
80: pqh_transaction_templates_bk1.create_transaction_template_a
81: (
82: p_transaction_template_id => l_transaction_template_id
83: ,p_enable_flag => p_enable_flag
84: ,p_template_id => p_template_id
157: --
158: -- Declare cursors and local variables
159: --
160: l_proc varchar2(72) := g_package||'update_transaction_template';
161: l_object_version_number pqh_transaction_templates.object_version_number%TYPE;
162: --
163: begin
164: --
165: hr_utility.set_location('Entering:'|| l_proc, 10);
177: begin
178: --
179: -- Start of API User Hook for the before hook of update_transaction_template
180: --
181: pqh_transaction_templates_bk2.update_transaction_template_b
182: (
183: p_transaction_template_id => p_transaction_template_id
184: ,p_enable_flag => p_enable_flag
185: ,p_template_id => p_template_id
213: begin
214: --
215: -- Start of API User Hook for the after hook of update_transaction_template
216: --
217: pqh_transaction_templates_bk2.update_transaction_template_a
218: (
219: p_transaction_template_id => p_transaction_template_id
220: ,p_enable_flag => p_enable_flag
221: ,p_template_id => p_template_id
286: --
287: -- Declare cursors and local variables
288: --
289: l_proc varchar2(72) := g_package||'update_transaction_template';
290: l_object_version_number pqh_transaction_templates.object_version_number%TYPE;
291: --
292: begin
293: --
294: hr_utility.set_location('Entering:'|| l_proc, 10);
307: begin
308: --
309: -- Start of API User Hook for the before hook of delete_transaction_template
310: --
311: pqh_transaction_templates_bk3.delete_transaction_template_b
312: (
313: p_transaction_template_id => p_transaction_template_id
314: ,p_object_version_number => p_object_version_number
315: ,p_effective_date => trunc(p_effective_date)
335: begin
336: --
337: -- Start of API User Hook for the after hook of delete_transaction_template
338: --
339: pqh_transaction_templates_bk3.delete_transaction_template_a
340: (
341: p_transaction_template_id => p_transaction_template_id
342: ,p_object_version_number => l_object_version_number
343: ,p_effective_date => trunc(p_effective_date)
414: hr_utility.set_location(' Leaving:'||l_proc, 70);
415: --
416: end lck;
417: --
418: end pqh_transaction_templates_api;