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 480: insert into pqh_templates(

476: --
477: -- Insert row into the base table
478: --
479:
480: insert into pqh_templates(
481: template_name,
482: template_id,
483: attribute_only_flag,
484: enable_flag,

Line 520: insert into pqh_templates_tl(

516: p_short_name
517: );
518: --
519:
520: insert into pqh_templates_tl(
521: template_id,
522: template_name,
523: language,
524: source_lang,

Line 544: from pqh_templates_tl ttl

540: l_last_update_login
541: from fnd_languages l
542: where l.installed_flag in ('I','B')
543: and not exists (select null
544: from pqh_templates_tl ttl
545: where ttl.template_id = l_template_id
546: and ttl.language = l.language_code );
547: --
548: --

Line 563: delete from PQH_TEMPLATES_TL T

559: --
560: Procedure ADD_LANGUAGE
561: is
562: begin
563: delete from PQH_TEMPLATES_TL T
564: where not exists
565: (select NULL
566: from PQH_TEMPLATES B
567: where B.TEMPLATE_ID = T.TEMPLATE_ID

Line 566: from PQH_TEMPLATES B

562: begin
563: delete from PQH_TEMPLATES_TL T
564: where not exists
565: (select NULL
566: from PQH_TEMPLATES B
567: where B.TEMPLATE_ID = T.TEMPLATE_ID
568: );
569:
570: update PQH_TEMPLATES_TL T set (

Line 570: update PQH_TEMPLATES_TL T set (

566: from PQH_TEMPLATES B
567: where B.TEMPLATE_ID = T.TEMPLATE_ID
568: );
569:
570: update PQH_TEMPLATES_TL T set (
571: TEMPLATE_NAME
572: ) = (select
573: B.TEMPLATE_NAME
574: from PQH_TEMPLATES_TL B

Line 574: from PQH_TEMPLATES_TL B

570: update PQH_TEMPLATES_TL T set (
571: TEMPLATE_NAME
572: ) = (select
573: B.TEMPLATE_NAME
574: from PQH_TEMPLATES_TL B
575: where B.TEMPLATE_ID = T.TEMPLATE_ID
576: and B.LANGUAGE = T.SOURCE_LANG)
577: where (
578: T.TEMPLATE_ID,

Line 583: from PQH_TEMPLATES_TL SUBB, PQH_TEMPLATES_TL SUBT

579: T.LANGUAGE
580: ) in (select
581: SUBT.TEMPLATE_ID,
582: SUBT.LANGUAGE
583: from PQH_TEMPLATES_TL SUBB, PQH_TEMPLATES_TL SUBT
584: where SUBB.TEMPLATE_ID = SUBT.TEMPLATE_ID
585: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
586: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
587: ));

Line 589: insert into PQH_TEMPLATES_TL (

585: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
586: and (SUBB.TEMPLATE_NAME <> SUBT.TEMPLATE_NAME
587: ));
588:
589: insert into PQH_TEMPLATES_TL (
590: TEMPLATE_ID,
591: TEMPLATE_NAME,
592: LAST_UPDATE_DATE,
593: CREATION_DATE,

Line 609: from PQH_TEMPLATES_TL B, FND_LANGUAGES L

605: B.LAST_UPDATE_LOGIN,
606: B.LAST_UPDATED_BY,
607: L.LANGUAGE_CODE,
608: B.SOURCE_LANG
609: from PQH_TEMPLATES_TL B, FND_LANGUAGES L
610: where L.INSTALLED_FLAG in ('I', 'B')
611: and B.LANGUAGE = userenv('LANG')
612: and not exists
613: (select NULL

Line 614: from PQH_TEMPLATES_TL T

610: where L.INSTALLED_FLAG in ('I', 'B')
611: and B.LANGUAGE = userenv('LANG')
612: and not exists
613: (select NULL
614: from PQH_TEMPLATES_TL T
615: where T.TEMPLATE_ID = B.TEMPLATE_ID
616: and T.LANGUAGE = L.LANGUAGE_CODE);
617: end ADD_LANGUAGE;
618: -- --