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_RTM_BUS dependencies on PQH_RTM_SHD

Line 46: l_api_updating := pqh_rtm_shd.api_updating

42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqh_rtm_shd.api_updating
47: (p_role_template_id => p_role_template_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating

Line 52: <> pqh_rtm_shd.g_old_rec.role_template_id) then

48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_role_template_id,hr_api.g_number)
52: <> pqh_rtm_shd.g_old_rec.role_template_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_rtm_shd.constraint_error('RTM_PK');

Line 56: pqh_rtm_shd.constraint_error('RTM_PK');

52: <> pqh_rtm_shd.g_old_rec.role_template_id) then
53: --
54: -- raise error as PK has changed
55: --
56: pqh_rtm_shd.constraint_error('RTM_PK');
57: --
58: elsif not l_api_updating then
59: --
60: -- check if PK is null

Line 66: pqh_rtm_shd.constraint_error('RTM_PK');

62: if p_role_template_id is not null then
63: --
64: -- raise error as PK is not null
65: --
66: pqh_rtm_shd.constraint_error('RTM_PK');
67: --
68: end if;
69: --
70: end if;

Line 118: l_api_updating := pqh_rtm_shd.api_updating

114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqh_rtm_shd.api_updating
119: (p_role_template_id => p_role_template_id,
120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating

Line 124: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and nvl(p_template_id,hr_api.g_number)
124: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number)
125: or not l_api_updating) and
126: p_template_id is not null then
127: --
128: -- check if template_id value exists in pqh_templates table

Line 140: pqh_rtm_shd.constraint_error('PQH_ROLE_TEMPLATES_FK3');

136: --
137: -- raise error as FK does not relate to PK in pqh_templates
138: -- table.
139: --
140: pqh_rtm_shd.constraint_error('PQH_ROLE_TEMPLATES_FK3');
141: --
142: end if;
143: --
144: close c1;

Line 194: l_api_updating := pqh_rtm_shd.api_updating

190: Begin
191: --
192: hr_utility.set_location('Entering:'||l_proc,5);
193: --
194: l_api_updating := pqh_rtm_shd.api_updating
195: (p_role_template_id => p_role_template_id,
196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating

Line 200: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)

196: p_object_version_number => p_object_version_number);
197: --
198: if (l_api_updating
199: and nvl(p_transaction_category_id,hr_api.g_number)
200: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if transaction_category_id value exists in pqh_transaction_categories table
204: --

Line 215: pqh_rtm_shd.constraint_error('PQH_ROLE_TEMPLATES_FK2');

211: --
212: -- raise error as FK does not relate to PK in pqh_transaction_categories
213: -- table.
214: --
215: pqh_rtm_shd.constraint_error('PQH_ROLE_TEMPLATES_FK2');
216: --
217: end if;
218: --
219: close c1;

Line 269: l_api_updating := pqh_rtm_shd.api_updating

265: Begin
266: --
267: hr_utility.set_location('Entering:'||l_proc,5);
268: --
269: l_api_updating := pqh_rtm_shd.api_updating
270: (p_role_template_id => p_role_template_id,
271: p_object_version_number => p_object_version_number);
272: --
273: if (l_api_updating

Line 275: <> nvl(pqh_rtm_shd.g_old_rec.role_id,hr_api.g_number)

271: p_object_version_number => p_object_version_number);
272: --
273: if (l_api_updating
274: and nvl(p_role_id,hr_api.g_number)
275: <> nvl(pqh_rtm_shd.g_old_rec.role_id,hr_api.g_number)
276: or not l_api_updating) then
277: --
278: -- check if role_id value exists in pqh_roles table
279: --

Line 290: pqh_rtm_shd.constraint_error('PQH_ROLE_TEMPLATES_FK1');

286: --
287: -- raise error as FK does not relate to PK in pqh_roles
288: -- table.
289: --
290: pqh_rtm_shd.constraint_error('PQH_ROLE_TEMPLATES_FK1');
291: --
292: end if;
293: --
294: close c1;

Line 346: l_api_updating := pqh_rtm_shd.api_updating

342: Begin
343: --
344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: l_api_updating := pqh_rtm_shd.api_updating
347: (p_role_template_id => p_role_template_id,
348: p_object_version_number => p_object_version_number);
349: --
350: if (l_api_updating

Line 352: <> nvl(pqh_rtm_shd.g_old_rec.enable_flag,hr_api.g_varchar2)

348: p_object_version_number => p_object_version_number);
349: --
350: if (l_api_updating
351: and p_enable_flag
352: <> nvl(pqh_rtm_shd.g_old_rec.enable_flag,hr_api.g_varchar2)
353: or not l_api_updating) then
354: --
355: -- check if value of lookup falls within lookup type.
356: --

Line 484: l_api_updating := pqh_rtm_shd.api_updating

480: Begin
481: --
482: hr_utility.set_location('Entering:'||l_proc,5);
483: --
484: l_api_updating := pqh_rtm_shd.api_updating
485: (p_role_template_id => p_role_template_id,
486: p_object_version_number => p_object_version_number);
487: --
488: if (l_api_updating

Line 490: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)

486: p_object_version_number => p_object_version_number);
487: --
488: if (l_api_updating
489: and (nvl(p_transaction_category_id,hr_api.g_number)
490: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)
491: or nvl(p_template_id,hr_api.g_number)
492: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number) )
493: or not l_api_updating) and
494: (p_transaction_category_id is not null

Line 492: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number) )

488: if (l_api_updating
489: and (nvl(p_transaction_category_id,hr_api.g_number)
490: <> nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number)
491: or nvl(p_template_id,hr_api.g_number)
492: <> nvl(pqh_rtm_shd.g_old_rec.template_id,hr_api.g_number) )
493: or not l_api_updating) and
494: (p_transaction_category_id is not null
495: or p_template_id is not null) then
496: --

Line 509: pqh_rtm_shd.constraint_error('RTM_TCT_TEM_FK');

505: --
506: -- raise error as FK does not relate to PK in pqh_templates
507: -- table.
508: --
509: pqh_rtm_shd.constraint_error('RTM_TCT_TEM_FK');
510: --
511: end if;
512: --
513: close c1;

Line 545: Procedure chk_non_updateable_args (p_rec in pqh_rtm_shd.g_rec_type ) is

541: --
542: -- Access Status
543: -- Internal table handler use only.
544: --
545: Procedure chk_non_updateable_args (p_rec in pqh_rtm_shd.g_rec_type ) is
546: --
547: l_proc varchar2(72) := g_package||'chk_non_updateable_args';
548: l_api_updating boolean;
549: l_error exception;

Line 557: l_api_updating := pqh_rtm_shd.api_updating

553: Begin
554: --
555: hr_utility.set_location('Entering:'||l_proc,5);
556: --
557: l_api_updating := pqh_rtm_shd.api_updating
558: (p_role_template_id => p_rec.role_template_id,
559: p_object_version_number => p_rec.object_version_number);
560: --
561: if (not l_api_updating ) then

Line 570: nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number) then

566: --
567: hr_utility.set_location('Leaving:'||l_proc,20);
568:
569: if nvl(p_rec.transaction_category_id,hr_api.g_number) <>
570: nvl(pqh_rtm_shd.g_old_rec.transaction_category_id,hr_api.g_number) then
571: l_argument := 'transaction_category_id';
572: raise l_error;
573: end if;
574: hr_utility.set_location(l_proc,30);

Line 591: Procedure insert_validate(p_rec in pqh_rtm_shd.g_rec_type

587: --
588: -- ----------------------------------------------------------------------------
589: -- |---------------------------< insert_validate >----------------------------|
590: -- ----------------------------------------------------------------------------
591: Procedure insert_validate(p_rec in pqh_rtm_shd.g_rec_type
592: ,p_effective_date in date) is
593: --
594: l_proc varchar2(72) := g_package||'insert_validate';
595: --

Line 641: Procedure update_validate(p_rec in pqh_rtm_shd.g_rec_type

637: --
638: -- ----------------------------------------------------------------------------
639: -- |---------------------------< update_validate >----------------------------|
640: -- ----------------------------------------------------------------------------
641: Procedure update_validate(p_rec in pqh_rtm_shd.g_rec_type
642: ,p_effective_date in date) is
643: --
644: l_proc varchar2(72) := g_package||'update_validate';
645: --

Line 692: Procedure delete_validate(p_rec in pqh_rtm_shd.g_rec_type

688: --
689: -- ----------------------------------------------------------------------------
690: -- |---------------------------< delete_validate >----------------------------|
691: -- ----------------------------------------------------------------------------
692: Procedure delete_validate(p_rec in pqh_rtm_shd.g_rec_type
693: ,p_effective_date in date) is
694: --
695: l_proc varchar2(72) := g_package||'delete_validate';
696: --