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_TEM_SHD dependencies on PQH_TEMPLATES

Line 21: If (p_constraint_name = 'PQH_TEMPLATES_FK') Then

17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PQH_TEMPLATES_FK') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;

Line 26: ElsIf (p_constraint_name = 'PQH_TEMPLATES_PK') Then

22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
26: ElsIf (p_constraint_name = 'PQH_TEMPLATES_PK') Then
27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;

Line 31: ElsIf (p_constraint_name = 'PQH_TEMPLATES_FK2') Then

27: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
28: hr_utility.set_message_token('PROCEDURE', l_proc);
29: hr_utility.set_message_token('STEP','10');
30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_TEMPLATES_FK2') Then
32: hr_utility.set_message(8302, 'PQH_TEM_LEG_CODE_NOT_EXIST');
33: hr_utility.raise_error;
34: ElsIf (p_constraint_name = 'PQH_TEMPLATES_UK') Then
35: hr_utility.set_message(8302, 'PQH_DUPLICATE_TEM_SHORT_NAME');

Line 34: ElsIf (p_constraint_name = 'PQH_TEMPLATES_UK') Then

30: hr_utility.raise_error;
31: ElsIf (p_constraint_name = 'PQH_TEMPLATES_FK2') Then
32: hr_utility.set_message(8302, 'PQH_TEM_LEG_CODE_NOT_EXIST');
33: hr_utility.raise_error;
34: ElsIf (p_constraint_name = 'PQH_TEMPLATES_UK') Then
35: hr_utility.set_message(8302, 'PQH_DUPLICATE_TEM_SHORT_NAME');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PQH_TRANSACTION_TEMPLATE_FK2') Then
38: hr_utility.set_message(8302, 'PQH_TRANS_TEMPLATE_FK_EXIST');

Line 79: from pqh_templates

75: object_version_number,
76: freeze_status_cd,
77: template_type_cd,
78: legislation_code
79: from pqh_templates
80: where template_id = p_template_id;
81: --
82: l_proc varchar2(72) := g_package||'api_updating';
83: l_fct_ret boolean;

Line 160: from pqh_templates

156: object_version_number,
157: freeze_status_cd,
158: template_type_cd,
159: legislation_code
160: from pqh_templates
161: where template_id = p_template_id
162: for update nowait;
163: --
164: l_proc varchar2(72) := g_package||'lck';

Line 203: hr_utility.set_message_token('TABLE_NAME', 'pqh_templates');

199: -- The object is locked therefore we need to supply a meaningful
200: -- error message.
201: --
202: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
203: hr_utility.set_message_token('TABLE_NAME', 'pqh_templates');
204: hr_utility.raise_error;
205: End lck;
206: --
207: -- ----------------------------------------------------------------------------

Line 333: l_template_id pqh_templates.template_id%type := 0;

329: l_object_version_number number := 1;
330: l_language varchar2(30) ;
331:
332: --
333: l_template_id pqh_templates.template_id%type := 0;
334: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
335: --
336: --
337: l_created_by pqh_templates.created_by%TYPE;

Line 337: l_created_by pqh_templates.created_by%TYPE;

333: l_template_id pqh_templates.template_id%type := 0;
334: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
335: --
336: --
337: l_created_by pqh_templates.created_by%TYPE;
338: l_last_updated_by pqh_templates.last_updated_by%TYPE;
339: l_creation_date pqh_templates.creation_date%TYPE;
340: l_last_update_date pqh_templates.last_update_date%TYPE;
341: l_last_update_login pqh_templates.last_update_login%TYPE;

Line 338: l_last_updated_by pqh_templates.last_updated_by%TYPE;

334: l_transaction_category_id pqh_transaction_categories.transaction_category_id%type;
335: --
336: --
337: l_created_by pqh_templates.created_by%TYPE;
338: l_last_updated_by pqh_templates.last_updated_by%TYPE;
339: l_creation_date pqh_templates.creation_date%TYPE;
340: l_last_update_date pqh_templates.last_update_date%TYPE;
341: l_last_update_login pqh_templates.last_update_login%TYPE;
342: --

Line 339: l_creation_date pqh_templates.creation_date%TYPE;

335: --
336: --
337: l_created_by pqh_templates.created_by%TYPE;
338: l_last_updated_by pqh_templates.last_updated_by%TYPE;
339: l_creation_date pqh_templates.creation_date%TYPE;
340: l_last_update_date pqh_templates.last_update_date%TYPE;
341: l_last_update_login pqh_templates.last_update_login%TYPE;
342: --
343: --

Line 340: l_last_update_date pqh_templates.last_update_date%TYPE;

336: --
337: l_created_by pqh_templates.created_by%TYPE;
338: l_last_updated_by pqh_templates.last_updated_by%TYPE;
339: l_creation_date pqh_templates.creation_date%TYPE;
340: l_last_update_date pqh_templates.last_update_date%TYPE;
341: l_last_update_login pqh_templates.last_update_login%TYPE;
342: --
343: --
344: cursor c1 is select userenv('LANG') from dual ;

Line 341: l_last_update_login pqh_templates.last_update_login%TYPE;

337: l_created_by pqh_templates.created_by%TYPE;
338: l_last_updated_by pqh_templates.last_updated_by%TYPE;
339: l_creation_date pqh_templates.creation_date%TYPE;
340: l_last_update_date pqh_templates.last_update_date%TYPE;
341: l_last_update_login pqh_templates.last_update_login%TYPE;
342: --
343: --
344: cursor c1 is select userenv('LANG') from dual ;
345: --

Line 352: from pqh_templates

348: where short_name = p_tran_cat_short_name
349: and business_group_id is null;
350: --
351: Cursor c3 is select template_id
352: from pqh_templates
353: where short_name = p_short_name ;
354: --
355: --
356: Cursor C_Sel1 is select pqh_templates_s.nextval from sys.dual;

Line 356: Cursor C_Sel1 is select pqh_templates_s.nextval from sys.dual;

352: from pqh_templates
353: where short_name = p_short_name ;
354: --
355: --
356: Cursor C_Sel1 is select pqh_templates_s.nextval from sys.dual;
357: --
358: --
359: BEGIN
360: --

Line 401: update pqh_templates

397: If l_template_id <> 0 then
398: --
399: -- If there is a row for the rule sets update the row in the base table
400: --
401: update pqh_templates
402: set
403: template_name = p_template_name,
404: short_name = p_short_name,
405: attribute_only_flag = p_attribute_only_flag,

Line 422: UPDATE pqh_templates_tl

418: --
419: -- update the tl table
420: if (sql%found) then
421: --
422: UPDATE pqh_templates_tl
423: SET template_name = p_template_name,
424: last_updated_by = l_last_updated_by,
425: last_update_date = l_last_update_date,
426: last_update_login = l_last_update_login,

Line 435: insert into pqh_templates_tl(

431: If (sql%notfound) then
432: -- no row in TL table so insert row
433:
434: --
435: insert into pqh_templates_tl(
436: template_id,
437: template_name,
438: language,
439: source_lang,

Line 459: from pqh_templates_tl ttl

455: l_last_update_login
456: from fnd_languages l
457: where l.installed_flag in ('I','B')
458: and not exists (select null
459: from pqh_templates_tl ttl
460: where ttl.template_id = l_template_id
461: and ttl.language = l.language_code );
462: --
463: --

Line 482: p_entity_name=> 'PQH_TEMPLATES',

478: -- Added the following code as a part of Zero Downtime Patching Project.
479: -- Code Starts Here.
480: --
481: per_ric_pkg.Chk_integrity (
482: p_entity_name=> 'PQH_TEMPLATES',
483: p_ref_entity=>'PQH_TRANSACTION_CATEGORIES',
484: p_ref_column_name=>'TRANSACTION_CATEGORY_ID',
485: p_ref_col_value_number=>l_transaction_category_id,
486: p_ref_col_value_varchar=>NULL,

Line 496: insert into pqh_templates(

492: --
493: -- Insert row into the base table
494: --
495:
496: insert into pqh_templates(
497: template_name,
498: template_id,
499: attribute_only_flag,
500: enable_flag,

Line 536: insert into pqh_templates_tl(

532: p_short_name
533: );
534: --
535:
536: insert into pqh_templates_tl(
537: template_id,
538: template_name,
539: language,
540: source_lang,

Line 560: from pqh_templates_tl ttl

556: l_last_update_login
557: from fnd_languages l
558: where l.installed_flag in ('I','B')
559: and not exists (select null
560: from pqh_templates_tl ttl
561: where ttl.template_id = l_template_id
562: and ttl.language = l.language_code );
563: --
564: --

Line 579: delete from PQH_TEMPLATES_TL T

575: --
576: Procedure ADD_LANGUAGE
577: is
578: begin
579: delete from PQH_TEMPLATES_TL T
580: where not exists
581: (select NULL
582: from PQH_TEMPLATES B
583: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 582: from PQH_TEMPLATES B

578: begin
579: delete from PQH_TEMPLATES_TL T
580: where not exists
581: (select NULL
582: from PQH_TEMPLATES B
583: where B.TEMPLATE_ID = T.TEMPLATE_ID
584: );
585:
586: update PQH_TEMPLATES_TL T set (

Line 586: update PQH_TEMPLATES_TL T set (

582: from PQH_TEMPLATES B
583: where B.TEMPLATE_ID = T.TEMPLATE_ID
584: );
585:
586: update PQH_TEMPLATES_TL T set (
587: TEMPLATE_NAME
588: ) = (select
589: B.TEMPLATE_NAME
590: from PQH_TEMPLATES_TL B

Line 590: from PQH_TEMPLATES_TL B

586: update PQH_TEMPLATES_TL T set (
587: TEMPLATE_NAME
588: ) = (select
589: B.TEMPLATE_NAME
590: from PQH_TEMPLATES_TL B
591: where B.TEMPLATE_ID = T.TEMPLATE_ID
592: and B.LANGUAGE = T.SOURCE_LANG)
593: where (
594: T.TEMPLATE_ID,

Line 599: from PQH_TEMPLATES_TL SUBB, PQH_TEMPLATES_TL SUBT

595: T.LANGUAGE
596: ) in (select
597: SUBT.TEMPLATE_ID,
598: SUBT.LANGUAGE
599: from PQH_TEMPLATES_TL SUBB, PQH_TEMPLATES_TL SUBT
600: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
601: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
602: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
603: ));

Line 605: insert into PQH_TEMPLATES_TL (

601: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
602: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
603: ));
604:
605: insert into PQH_TEMPLATES_TL (
606: TEMPLATE_ID,
607: TEMPLATE_NAME,
608: LAST_UPDATE_DATE,
609: CREATION_DATE,

Line 625: from PQH_TEMPLATES_TL B, FND_LANGUAGES L

621: B.LAST_UPDATE_LOGIN,
622: B.LAST_UPDATED_BY,
623: L.LANGUAGE_CODE,
624: B.SOURCE_LANG
625: from PQH_TEMPLATES_TL B, FND_LANGUAGES L
626: where L.INSTALLED_FLAG in ('I', 'B')
627: and B.LANGUAGE = userenv('LANG')
628: and not exists
629: (select NULL

Line 630: from PQH_TEMPLATES_TL T

626: where L.INSTALLED_FLAG in ('I', 'B')
627: and B.LANGUAGE = userenv('LANG')
628: and not exists
629: (select NULL
630: from PQH_TEMPLATES_TL T
631: where T.TEMPLATE_ID = B.TEMPLATE_ID
632: and T.LANGUAGE = L.LANGUAGE_CODE);
633: end ADD_LANGUAGE;
634: -- --