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_RST_SHD dependencies on PQH_RULE_SETS

Line 27: ElsIf (p_constraint_name = 'PQH_RULE_SETS_FK2') Then

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

Line 32: ElsIf (p_constraint_name = 'PQH_RULE_SETS_FK3') Then

28: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29: hr_utility.set_message_token('PROCEDURE', l_proc);
30: hr_utility.set_message_token('STEP','10');
31: hr_utility.raise_error;
32: ElsIf (p_constraint_name = 'PQH_RULE_SETS_FK3') Then
33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;

Line 37: ElsIf (p_constraint_name = 'PQH_RULE_SETS_FK4') Then

33: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
34: hr_utility.set_message_token('PROCEDURE', l_proc);
35: hr_utility.set_message_token('STEP','15');
36: hr_utility.raise_error;
37: ElsIf (p_constraint_name = 'PQH_RULE_SETS_FK4') Then
38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;

Line 42: ElsIf (p_constraint_name = 'PQH_RULE_SETS_UK') Then

38: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39: hr_utility.set_message_token('PROCEDURE', l_proc);
40: hr_utility.set_message_token('STEP','20');
41: hr_utility.raise_error;
42: ElsIf (p_constraint_name = 'PQH_RULE_SETS_UK') Then
43: hr_utility.set_message(8302, 'PQH_DUPL_SHORT_NAME');
44: hr_utility.raise_error;
45: ElsIf (p_constraint_name = 'RULE_SETS_PK') Then
46: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

Line 88: from pqh_rule_sets

84: rule_category,
85: starting_organization_id,
86: seeded_rule_flag,
87: status
88: from pqh_rule_sets
89: where rule_set_id = p_rule_set_id;
90: --
91: l_proc varchar2(72) := g_package||'api_updating';
92: l_fct_ret boolean;

Line 171: from pqh_rule_sets

167: rule_category,
168: starting_organization_id,
169: seeded_rule_flag,
170: status
171: from pqh_rule_sets
172: where rule_set_id = p_rule_set_id
173: for update nowait;
174: --
175: l_proc varchar2(72) := g_package||'lck';

Line 214: hr_utility.set_message_token('TABLE_NAME', 'pqh_rule_sets');

210: -- The object is locked therefore we need to supply a meaningful
211: -- error message.
212: --
213: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
214: hr_utility.set_message_token('TABLE_NAME', 'pqh_rule_sets');
215: hr_utility.raise_error;
216: End lck;
217: --
218: -- ----------------------------------------------------------------------------

Line 290: l_rule_set_id pqh_rule_sets.rule_set_id%type := 0;

286: l_object_version_number number := 1;
287: l_language varchar2(30) ;
288:
289: --
290: l_rule_set_id pqh_rule_sets.rule_set_id%type := 0;
291: l_referenced_rule_set_id pqh_rule_sets.referenced_rule_set_id%type;
292: --
293: --
294: l_created_by pqh_rule_sets.created_by%TYPE;

Line 291: l_referenced_rule_set_id pqh_rule_sets.referenced_rule_set_id%type;

287: l_language varchar2(30) ;
288:
289: --
290: l_rule_set_id pqh_rule_sets.rule_set_id%type := 0;
291: l_referenced_rule_set_id pqh_rule_sets.referenced_rule_set_id%type;
292: --
293: --
294: l_created_by pqh_rule_sets.created_by%TYPE;
295: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;

Line 294: l_created_by pqh_rule_sets.created_by%TYPE;

290: l_rule_set_id pqh_rule_sets.rule_set_id%type := 0;
291: l_referenced_rule_set_id pqh_rule_sets.referenced_rule_set_id%type;
292: --
293: --
294: l_created_by pqh_rule_sets.created_by%TYPE;
295: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;
296: l_creation_date pqh_rule_sets.creation_date%TYPE;
297: l_last_update_date pqh_rule_sets.last_update_date%TYPE;
298: l_last_update_login pqh_rule_sets.last_update_login%TYPE;

Line 295: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;

291: l_referenced_rule_set_id pqh_rule_sets.referenced_rule_set_id%type;
292: --
293: --
294: l_created_by pqh_rule_sets.created_by%TYPE;
295: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;
296: l_creation_date pqh_rule_sets.creation_date%TYPE;
297: l_last_update_date pqh_rule_sets.last_update_date%TYPE;
298: l_last_update_login pqh_rule_sets.last_update_login%TYPE;
299: --

Line 296: l_creation_date pqh_rule_sets.creation_date%TYPE;

292: --
293: --
294: l_created_by pqh_rule_sets.created_by%TYPE;
295: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;
296: l_creation_date pqh_rule_sets.creation_date%TYPE;
297: l_last_update_date pqh_rule_sets.last_update_date%TYPE;
298: l_last_update_login pqh_rule_sets.last_update_login%TYPE;
299: --
300: --

Line 297: l_last_update_date pqh_rule_sets.last_update_date%TYPE;

293: --
294: l_created_by pqh_rule_sets.created_by%TYPE;
295: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;
296: l_creation_date pqh_rule_sets.creation_date%TYPE;
297: l_last_update_date pqh_rule_sets.last_update_date%TYPE;
298: l_last_update_login pqh_rule_sets.last_update_login%TYPE;
299: --
300: --
301: cursor c1 is select userenv('LANG') from dual ;

Line 298: l_last_update_login pqh_rule_sets.last_update_login%TYPE;

294: l_created_by pqh_rule_sets.created_by%TYPE;
295: l_last_updated_by pqh_rule_sets.last_updated_by%TYPE;
296: l_creation_date pqh_rule_sets.creation_date%TYPE;
297: l_last_update_date pqh_rule_sets.last_update_date%TYPE;
298: l_last_update_login pqh_rule_sets.last_update_login%TYPE;
299: --
300: --
301: cursor c1 is select userenv('LANG') from dual ;
302: --

Line 305: from pqh_rule_sets

301: cursor c1 is select userenv('LANG') from dual ;
302: --
303: Cursor c5(p_short_name in varchar2) is
304: select rule_set_id
305: from pqh_rule_sets
306: where short_name = p_short_name ;
307: --
308: --
309: Cursor C_Sel1 is select pqh_rule_sets_s.nextval from sys.dual;

Line 309: Cursor C_Sel1 is select pqh_rule_sets_s.nextval from sys.dual;

305: from pqh_rule_sets
306: where short_name = p_short_name ;
307: --
308: --
309: Cursor C_Sel1 is select pqh_rule_sets_s.nextval from sys.dual;
310: --
311: --
312: BEGIN
313: --

Line 354: update pqh_rule_sets

350: --
351: -- If there is a row for the rule sets
352: -- update the row in the base table
353: --
354: update pqh_rule_sets
355: set
356: rule_set_name = p_rule_set_name,
357: short_name = p_short_name,
358: referenced_rule_set_id = l_referenced_rule_set_id,

Line 372: UPDATE pqh_rule_sets_tl

368: --
369: -- update the tl table
370: --
371: if sql%found then
372: UPDATE pqh_rule_sets_tl
373: SET rule_set_name = p_rule_set_name,
374: description = p_description,
375: last_updated_by = l_last_updated_by,
376: last_update_date = l_last_update_date,

Line 386: insert into pqh_rule_sets_tl(

382: If (sql%notfound) then
383: -- no row in TL table so insert row
384:
385: --
386: insert into pqh_rule_sets_tl(
387: rule_set_id,
388: rule_set_name,
389: description,
390: language,

Line 412: from pqh_rule_sets_tl rtl

408: l_last_update_login
409: from fnd_languages l
410: where l.installed_flag in ('I','B')
411: and not exists (select null
412: from pqh_rule_sets_tl rtl
413: where rtl.rule_set_id = l_rule_set_id
414: and rtl.language = l.language_code );
415: --
416: --

Line 432: insert into pqh_rule_sets(

428: --
429: -- Insert row into the base table
430: --
431:
432: insert into pqh_rule_sets(
433: rule_set_id,
434: rule_set_name,
435: short_name,
436: referenced_rule_set_id,

Line 465: insert into pqh_rule_sets_tl(

461: l_last_update_login,
462: 'Y'
463: );
464:
465: insert into pqh_rule_sets_tl(
466: rule_set_id,
467: rule_set_name,
468: description,
469: language,

Line 491: from pqh_rule_sets_tl rtl

487: l_last_update_login
488: from fnd_languages l
489: where l.installed_flag in ('I','B')
490: and not exists (select null
491: from pqh_rule_sets_tl rtl
492: where rtl.rule_set_id = l_rule_set_id
493: and rtl.language = l.language_code );
494: --
495: --

Line 552: delete from PQH_RULE_SETS_TL T

548:
549: Procedure ADD_LANGUAGE
550: is
551: begin
552: delete from PQH_RULE_SETS_TL T
553: where not exists
554: (select NULL
555: from PQH_RULE_SETS B
556: where B.RULE_SET_ID = T.RULE_SET_ID

Line 555: from PQH_RULE_SETS B

551: begin
552: delete from PQH_RULE_SETS_TL T
553: where not exists
554: (select NULL
555: from PQH_RULE_SETS B
556: where B.RULE_SET_ID = T.RULE_SET_ID
557: );
558:
559: update PQH_RULE_SETS_TL T set (

Line 559: update PQH_RULE_SETS_TL T set (

555: from PQH_RULE_SETS B
556: where B.RULE_SET_ID = T.RULE_SET_ID
557: );
558:
559: update PQH_RULE_SETS_TL T set (
560: RULE_SET_NAME
561: ) = (select
562: B.RULE_SET_NAME
563: from PQH_RULE_SETS_TL B

Line 563: from PQH_RULE_SETS_TL B

559: update PQH_RULE_SETS_TL T set (
560: RULE_SET_NAME
561: ) = (select
562: B.RULE_SET_NAME
563: from PQH_RULE_SETS_TL B
564: where B.RULE_SET_ID = T.RULE_SET_ID
565: and B.LANGUAGE = T.SOURCE_LANG)
566: where (
567: T.RULE_SET_ID,

Line 572: from PQH_RULE_SETS_TL SUBB, PQH_RULE_SETS_TL SUBT

568: T.LANGUAGE
569: ) in (select
570: SUBT.RULE_SET_ID,
571: SUBT.LANGUAGE
572: from PQH_RULE_SETS_TL SUBB, PQH_RULE_SETS_TL SUBT
573: where SUBB.RULE_SET_ID = SUBT.RULE_SET_ID
574: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
575: and (SUBB.RULE_SET_NAME <> SUBT.RULE_SET_NAME
576: ));

Line 578: insert into PQH_RULE_SETS_TL (

574: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
575: and (SUBB.RULE_SET_NAME <> SUBT.RULE_SET_NAME
576: ));
577:
578: insert into PQH_RULE_SETS_TL (
579: RULE_SET_ID,
580: RULE_SET_NAME,
581: LAST_UPDATE_DATE,
582: CREATION_DATE,

Line 598: from PQH_RULE_SETS_TL B, FND_LANGUAGES L

594: B.LAST_UPDATE_LOGIN,
595: B.LAST_UPDATED_BY,
596: L.LANGUAGE_CODE,
597: B.SOURCE_LANG
598: from PQH_RULE_SETS_TL B, FND_LANGUAGES L
599: where L.INSTALLED_FLAG in ('I', 'B')
600: and B.LANGUAGE = userenv('LANG')
601: and not exists
602: (select NULL

Line 603: from PQH_RULE_SETS_TL T

599: where L.INSTALLED_FLAG in ('I', 'B')
600: and B.LANGUAGE = userenv('LANG')
601: and not exists
602: (select NULL
603: from PQH_RULE_SETS_TL T
604: where T.RULE_SET_ID = B.RULE_SET_ID
605: and T.LANGUAGE = L.LANGUAGE_CODE);
606: end ADD_LANGUAGE;
607: -- --