DBA Data[Home] [Help]

APPS.PQH_PROCESS_LOG_API dependencies on PQH_PROCESS_LOG

Line 1: Package Body pqh_process_log_api as

1: Package Body pqh_process_log_api as
2: /* $Header: pqplgapi.pkb 115.5 2002/12/06 18:06:42 rpasapul ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqplgapi.pkb 115.5 2002/12/06 18:06:42 rpasapul ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_process_log_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_process_log >----------------------|
10: -- ----------------------------------------------------------------------------

Line 62: l_process_log_id pqh_process_log.process_log_id%TYPE;

58: ) is
59: --
60: -- Declare cursors and local variables
61: --
62: l_process_log_id pqh_process_log.process_log_id%TYPE;
63: l_proc varchar2(72) := g_package||'create_process_log';
64: l_object_version_number pqh_process_log.object_version_number%TYPE;
65: --
66: begin

Line 64: l_object_version_number pqh_process_log.object_version_number%TYPE;

60: -- Declare cursors and local variables
61: --
62: l_process_log_id pqh_process_log.process_log_id%TYPE;
63: l_proc varchar2(72) := g_package||'create_process_log';
64: l_object_version_number pqh_process_log.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 82: pqh_process_log_bk1.create_process_log_b

78: begin
79: --
80: -- Start of API User Hook for the before hook of create_process_log
81: --
82: pqh_process_log_bk1.create_process_log_b
83: (
84: p_module_cd => p_module_cd
85: ,p_txn_id => p_txn_id
86: ,p_master_process_log_id => p_master_process_log_id

Line 191: pqh_process_log_bk1.create_process_log_a

187: begin
188: --
189: -- Start of API User Hook for the after hook of create_process_log
190: --
191: pqh_process_log_bk1.create_process_log_a
192: (
193: p_process_log_id => l_process_log_id
194: ,p_module_cd => p_module_cd
195: ,p_txn_id => p_txn_id

Line 346: l_object_version_number pqh_process_log.object_version_number%TYPE;

342: --
343: -- Declare cursors and local variables
344: --
345: l_proc varchar2(72) := g_package||'update_process_log';
346: l_object_version_number pqh_process_log.object_version_number%TYPE;
347: --
348: begin
349: --
350: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 366: pqh_process_log_bk2.update_process_log_b

362: begin
363: --
364: -- Start of API User Hook for the before hook of update_process_log
365: --
366: pqh_process_log_bk2.update_process_log_b
367: (
368: p_process_log_id => p_process_log_id
369: ,p_module_cd => p_module_cd
370: ,p_txn_id => p_txn_id

Line 476: pqh_process_log_bk2.update_process_log_a

472: begin
473: --
474: -- Start of API User Hook for the after hook of update_process_log
475: --
476: pqh_process_log_bk2.update_process_log_a
477: (
478: p_process_log_id => p_process_log_id
479: ,p_module_cd => p_module_cd
480: ,p_txn_id => p_txn_id

Line 586: l_object_version_number pqh_process_log.object_version_number%TYPE;

582: --
583: -- Declare cursors and local variables
584: --
585: l_proc varchar2(72) := g_package||'delete_process_log';
586: l_object_version_number pqh_process_log.object_version_number%TYPE;
587: --
588: begin
589: --
590: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 607: pqh_process_log_bk3.delete_process_log_b

603: begin
604: --
605: -- Start of API User Hook for the before hook of delete_process_log
606: --
607: pqh_process_log_bk3.delete_process_log_b
608: (
609: p_process_log_id => p_process_log_id
610: ,p_object_version_number => p_object_version_number
611: ,p_effective_date => trunc(p_effective_date)

Line 635: pqh_process_log_bk3.delete_process_log_a

631: begin
632: --
633: -- Start of API User Hook for the after hook of delete_process_log
634: --
635: pqh_process_log_bk3.delete_process_log_a
636: (
637: p_process_log_id => p_process_log_id
638: ,p_object_version_number => l_object_version_number
639: ,p_effective_date => trunc(p_effective_date)

Line 714: end pqh_process_log_api;

710: hr_utility.set_location(' Leaving:'||l_proc, 70);
711: --
712: end lck;
713: --
714: end pqh_process_log_api;