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_HISTORY_API dependencies on PQH_ROUTING_HISTORY

Line 1: Package Body pqh_routing_history_api as

1: Package Body pqh_routing_history_api as
2: /* $Header: pqrhtapi.pkb 115.6 2002/12/06 18:07:57 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqrhtapi.pkb 115.6 2002/12/06 18:07:57 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_routing_history_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_routing_history >----------------------|
10: -- ----------------------------------------------------------------------------

Line 42: l_routing_history_id pqh_routing_history.routing_history_id%TYPE;

38: ) is
39: --
40: -- Declare cursors and local variables
41: --
42: l_routing_history_id pqh_routing_history.routing_history_id%TYPE;
43: l_proc varchar2(72) := g_package||'create_routing_history';
44: l_object_version_number pqh_routing_history.object_version_number%TYPE;
45: --
46: begin

Line 44: l_object_version_number pqh_routing_history.object_version_number%TYPE;

40: -- Declare cursors and local variables
41: --
42: l_routing_history_id pqh_routing_history.routing_history_id%TYPE;
43: l_proc varchar2(72) := g_package||'create_routing_history';
44: l_object_version_number pqh_routing_history.object_version_number%TYPE;
45: --
46: begin
47: --
48: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 62: pqh_routing_history_bk1.create_routing_history_b

58: begin
59: --
60: -- Start of API User Hook for the before hook of create_routing_history
61: --
62: pqh_routing_history_bk1.create_routing_history_b
63: (
64: p_approval_cd => p_approval_cd
65: ,p_comments => p_comments
66: ,p_forwarded_by_assignment_id => p_forwarded_by_assignment_id

Line 131: pqh_routing_history_bk1.create_routing_history_a

127: begin
128: --
129: -- Start of API User Hook for the after hook of create_routing_history
130: --
131: pqh_routing_history_bk1.create_routing_history_a
132: (
133: p_routing_history_id => l_routing_history_id
134: ,p_approval_cd => p_approval_cd
135: ,p_comments => p_comments

Line 246: l_object_version_number pqh_routing_history.object_version_number%TYPE;

242: --
243: -- Declare cursors and local variables
244: --
245: l_proc varchar2(72) := g_package||'update_routing_history';
246: l_object_version_number pqh_routing_history.object_version_number%TYPE;
247: --
248: begin
249: --
250: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 266: pqh_routing_history_bk2.update_routing_history_b

262: begin
263: --
264: -- Start of API User Hook for the before hook of update_routing_history
265: --
266: pqh_routing_history_bk2.update_routing_history_b
267: (
268: p_routing_history_id => p_routing_history_id
269: ,p_approval_cd => p_approval_cd
270: ,p_comments => p_comments

Line 336: pqh_routing_history_bk2.update_routing_history_a

332: begin
333: --
334: -- Start of API User Hook for the after hook of update_routing_history
335: --
336: pqh_routing_history_bk2.update_routing_history_a
337: (
338: p_routing_history_id => p_routing_history_id
339: ,p_approval_cd => p_approval_cd
340: ,p_comments => p_comments

Line 426: l_object_version_number pqh_routing_history.object_version_number%TYPE;

422: --
423: -- Declare cursors and local variables
424: --
425: l_proc varchar2(72) := g_package||'update_routing_history';
426: l_object_version_number pqh_routing_history.object_version_number%TYPE;
427: --
428: begin
429: --
430: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 447: pqh_routing_history_bk3.delete_routing_history_b

443: begin
444: --
445: -- Start of API User Hook for the before hook of delete_routing_history
446: --
447: pqh_routing_history_bk3.delete_routing_history_b
448: (
449: p_routing_history_id => p_routing_history_id
450: ,p_object_version_number => p_object_version_number
451: ,p_effective_date => trunc(p_effective_date)

Line 484: pqh_routing_history_bk3.delete_routing_history_a

480: begin
481: --
482: -- Start of API User Hook for the after hook of delete_routing_history
483: --
484: pqh_routing_history_bk3.delete_routing_history_a
485: (
486: p_routing_history_id => p_routing_history_id
487: ,p_object_version_number => l_object_version_number
488: ,p_effective_date => trunc(p_effective_date)

Line 604: l_routing_history_id pqh_routing_history.routing_history_id%TYPE;

600: */
601:
602:
603: l_proc varchar2(72) := g_package||'create_routing_history_bp';
604: l_routing_history_id pqh_routing_history.routing_history_id%TYPE;
605: l_object_version_number pqh_routing_history.object_version_number%TYPE;
606: l_routing_hist_attrib_id pqh_routing_hist_attribs.routing_hist_attrib_id%TYPE;
607:
608: begin

Line 605: l_object_version_number pqh_routing_history.object_version_number%TYPE;

601:
602:
603: l_proc varchar2(72) := g_package||'create_routing_history_bp';
604: l_routing_history_id pqh_routing_history.routing_history_id%TYPE;
605: l_object_version_number pqh_routing_history.object_version_number%TYPE;
606: l_routing_hist_attrib_id pqh_routing_hist_attribs.routing_hist_attrib_id%TYPE;
607:
608: begin
609:

Line 688: end pqh_routing_history_api;

684: end create_routing_history_bp;
685: --
686: --
687: --
688: end pqh_routing_history_api;