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_CATEGORIES_API dependencies on PQH_ROUTING_CATEGORIES

Line 1: Package Body pqh_ROUTING_CATEGORIES_api as

1: Package Body pqh_ROUTING_CATEGORIES_api as
2: /* $Header: pqrctapi.pkb 115.11 2002/12/06 18:07:26 rpasapul noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: pqrctapi.pkb 115.11 2002/12/06 18:07:26 rpasapul noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' pqh_ROUTING_CATEGORIES_api.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |------------------------< create_ROUTING_CATEGORY >----------------------|
10: -- ----------------------------------------------------------------------------

Line 31: l_routing_category_id pqh_routing_categories.routing_category_id%TYPE;

27: ) is
28: --
29: -- Declare cursors and local variables
30: --
31: l_routing_category_id pqh_routing_categories.routing_category_id%TYPE;
32: l_proc varchar2(72) := g_package||'create_ROUTING_CATEGORY';
33: l_object_version_number pqh_routing_categories.object_version_number%TYPE;
34: --
35: begin

Line 33: l_object_version_number pqh_routing_categories.object_version_number%TYPE;

29: -- Declare cursors and local variables
30: --
31: l_routing_category_id pqh_routing_categories.routing_category_id%TYPE;
32: l_proc varchar2(72) := g_package||'create_ROUTING_CATEGORY';
33: l_object_version_number pqh_routing_categories.object_version_number%TYPE;
34: --
35: begin
36: --
37: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 51: pqh_ROUTING_CATEGORIES_bk1.create_ROUTING_CATEGORY_b

47: begin
48: --
49: -- Start of API User Hook for the before hook of create_ROUTING_CATEGORY
50: --
51: pqh_ROUTING_CATEGORIES_bk1.create_ROUTING_CATEGORY_b
52: (
53: p_transaction_category_id => p_transaction_category_id
54: ,p_enable_flag => p_enable_flag
55: ,p_default_flag => p_default_flag

Line 98: pqh_ROUTING_CATEGORIES_bk1.create_ROUTING_CATEGORY_a

94: begin
95: --
96: -- Start of API User Hook for the after hook of create_ROUTING_CATEGORY
97: --
98: pqh_ROUTING_CATEGORIES_bk1.create_ROUTING_CATEGORY_a
99: (
100: p_routing_category_id => l_routing_category_id
101: ,p_transaction_category_id => p_transaction_category_id
102: ,p_enable_flag => p_enable_flag

Line 192: l_object_version_number pqh_routing_categories.object_version_number%TYPE;

188: --
189: -- Declare cursors and local variables
190: --
191: l_proc varchar2(72) := g_package||'update_ROUTING_CATEGORY';
192: l_object_version_number pqh_routing_categories.object_version_number%TYPE;
193: --
194: begin
195: --
196: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 212: pqh_ROUTING_CATEGORIES_bk2.update_ROUTING_CATEGORY_b

208: begin
209: --
210: -- Start of API User Hook for the before hook of update_ROUTING_CATEGORY
211: --
212: pqh_ROUTING_CATEGORIES_bk2.update_ROUTING_CATEGORY_b
213: (
214: p_routing_category_id => p_routing_category_id
215: ,p_transaction_category_id => p_transaction_category_id
216: ,p_enable_flag => p_enable_flag

Line 262: pqh_ROUTING_CATEGORIES_bk2.update_ROUTING_CATEGORY_a

258: begin
259: --
260: -- Start of API User Hook for the after hook of update_ROUTING_CATEGORY
261: --
262: pqh_ROUTING_CATEGORIES_bk2.update_ROUTING_CATEGORY_a
263: (
264: p_routing_category_id => p_routing_category_id
265: ,p_transaction_category_id => p_transaction_category_id
266: ,p_enable_flag => p_enable_flag

Line 343: l_object_version_number pqh_routing_categories.object_version_number%TYPE;

339: --
340: -- Declare cursors and local variables
341: --
342: l_proc varchar2(72) := g_package||'delete_ROUTING_CATEGORY';
343: l_object_version_number pqh_routing_categories.object_version_number%TYPE;
344: --
345: begin
346: --
347: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 364: pqh_ROUTING_CATEGORIES_bk3.delete_ROUTING_CATEGORY_b

360: begin
361: --
362: -- Start of API User Hook for the before hook of delete_ROUTING_CATEGORY
363: --
364: pqh_ROUTING_CATEGORIES_bk3.delete_ROUTING_CATEGORY_b
365: (
366: p_routing_category_id => p_routing_category_id
367: ,p_object_version_number => p_object_version_number
368: ,p_effective_date => trunc(p_effective_date)

Line 394: pqh_ROUTING_CATEGORIES_bk3.delete_ROUTING_CATEGORY_a

390: begin
391: --
392: -- Start of API User Hook for the after hook of delete_ROUTING_CATEGORY
393: --
394: pqh_ROUTING_CATEGORIES_bk3.delete_ROUTING_CATEGORY_a
395: (
396: p_routing_category_id => p_routing_category_id
397: ,p_object_version_number => l_object_version_number
398: ,p_effective_date => trunc(p_effective_date)

Line 486: l_routing_category_id pqh_routing_categories.routing_category_id%type;

482: type cur_type IS REF CURSOR;
483: rct_cur cur_type;
484: sql_stmt varchar2(1000);
485: --
486: l_routing_category_id pqh_routing_categories.routing_category_id%type;
487: l_object_version_number pqh_routing_categories.object_version_number%type;
488: --
489: l_proc varchar2(72) := g_package||'disable_routing_categories';
490: --

Line 487: l_object_version_number pqh_routing_categories.object_version_number%type;

483: rct_cur cur_type;
484: sql_stmt varchar2(1000);
485: --
486: l_routing_category_id pqh_routing_categories.routing_category_id%type;
487: l_object_version_number pqh_routing_categories.object_version_number%type;
488: --
489: l_proc varchar2(72) := g_package||'disable_routing_categories';
490: --
491: Begin

Line 495: sql_stmt := 'Select routing_category_id,object_version_number from pqh_routing_categories where transaction_category_id = :t';

491: Begin
492: --
493: hr_utility.set_location('Entering:'|| l_proc, 10);
494: --
495: sql_stmt := 'Select routing_category_id,object_version_number from pqh_routing_categories where transaction_category_id = :t';
496: --
497: -- Select only the routing categories that belong to the current routing
498: -- type of the transaction category.
499: --

Line 526: pqh_ROUTING_CATEGORIES_api.update_ROUTING_CATEGORY

522: End if;
523: --
524: -- set all the selected routing categories to disabled.
525: --
526: pqh_ROUTING_CATEGORIES_api.update_ROUTING_CATEGORY
527: (p_validate => false
528: ,p_routing_category_id => l_routing_category_id
529: ,p_enable_flag => 'N'
530: ,p_object_version_number => l_object_version_number

Line 541: end pqh_ROUTING_CATEGORIES_api;

537: --
538: End;
539: --
540: --
541: end pqh_ROUTING_CATEGORIES_api;