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 433: insert into pqh_rule_sets(

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

Line 466: insert into pqh_rule_sets_tl(

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

Line 492: from pqh_rule_sets_tl rtl

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

Line 553: delete from PQH_RULE_SETS_TL T

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

Line 556: from PQH_RULE_SETS B

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

Line 560: update PQH_RULE_SETS_TL T set (

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

Line 564: from PQH_RULE_SETS_TL B

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

Line 573: from PQH_RULE_SETS_TL SUBB, PQH_RULE_SETS_TL SUBT

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

Line 579: insert into PQH_RULE_SETS_TL (

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

Line 599: from PQH_RULE_SETS_TL B, FND_LANGUAGES L

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

Line 604: from PQH_RULE_SETS_TL T

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