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

Line 16: l_rule_set_name pqh_rule_sets_tl.rule_set_name%type;

12: -- | LOCAL Functions |
13: -- ----------------------------------------------------------------------------
14: --
15: function get_rule_set_name (p_rule_set_id in number) return varchar2 is
16: l_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
17: cursor c1 is select rule_set_name
18: from pqh_rule_sets_vl
19: where rule_set_id = p_rule_set_id;
20: begin

Line 18: from pqh_rule_sets_vl

14: --
15: function get_rule_set_name (p_rule_set_id in number) return varchar2 is
16: l_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
17: cursor c1 is select rule_set_name
18: from pqh_rule_sets_vl
19: where rule_set_id = p_rule_set_id;
20: begin
21: open c1;
22: fetch c1 into l_rule_set_name;

Line 130: from pqh_rule_sets_vl

126: l_dummy varchar2(1);
127: --
128: Cursor csr_rst_name is
129: select null
130: from pqh_rule_sets_vl
131: where rule_set_name = p_rule_set_name;
132: --
133: l_proc varchar2(72) := g_package||'chk_rule_set_name';
134: --

Line 197: l_seeded_rule_flag pqh_rule_sets.seeded_rule_flag%type;

193: p_object_version_number in number) is
194: --
195: l_proc varchar2(72) := g_package||'chk_referenced_rule_set_id';
196: l_api_updating boolean;
197: l_seeded_rule_flag pqh_rule_sets.seeded_rule_flag%type;
198: l_rule_category pqh_rule_sets.rule_category%type;
199: l_ref_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
200: --
201: cursor c1 is

Line 198: l_rule_category pqh_rule_sets.rule_category%type;

194: --
195: l_proc varchar2(72) := g_package||'chk_referenced_rule_set_id';
196: l_api_updating boolean;
197: l_seeded_rule_flag pqh_rule_sets.seeded_rule_flag%type;
198: l_rule_category pqh_rule_sets.rule_category%type;
199: l_ref_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
200: --
201: cursor c1 is
202: select seeded_rule_flag,rule_set_name,rule_category

Line 199: l_ref_rule_set_name pqh_rule_sets_tl.rule_set_name%type;

195: l_proc varchar2(72) := g_package||'chk_referenced_rule_set_id';
196: l_api_updating boolean;
197: l_seeded_rule_flag pqh_rule_sets.seeded_rule_flag%type;
198: l_rule_category pqh_rule_sets.rule_category%type;
199: l_ref_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
200: --
201: cursor c1 is
202: select seeded_rule_flag,rule_set_name,rule_category
203: from pqh_rule_sets_vl

Line 203: from pqh_rule_sets_vl

199: l_ref_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
200: --
201: cursor c1 is
202: select seeded_rule_flag,rule_set_name,rule_category
203: from pqh_rule_sets_vl
204: where rule_set_id = p_referenced_rule_set_id;
205: --
206: Begin
207: --

Line 226: pqh_rst_shd.constraint_error('PQH_RULE_SETS_FK4');

222: open c1;
223: fetch c1 into l_seeded_rule_flag,l_ref_rule_set_name,l_rule_category;
224: if c1%notfound then
225: close c1;
226: pqh_rst_shd.constraint_error('PQH_RULE_SETS_FK4');
227: else
228: close c1;
229: if l_rule_category <> p_rule_category then
230: hr_utility.set_location ('rule category does not match with reference rule',10);

Line 320: pqh_rst_shd.constraint_error('PQH_RULE_SETS_FK3');

316: --
317: -- raise error as FK does not relate to PK in hr_all_organization_units
318: -- table.
319: --
320: pqh_rst_shd.constraint_error('PQH_RULE_SETS_FK3');
321: --
322: end if;
323: --
324: close c1;

Line 369: l_rule_set_name pqh_rule_sets_tl.rule_set_name%type;

365: --
366: l_proc varchar2(72) := g_package||'chk_duplicate_rule_set';
367: l_api_updating boolean;
368: l_business_group_id hr_all_organization_units.business_group_id%type;
369: l_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
370: l_rule_set_id pqh_rule_sets.rule_set_id%type;
371: --
372: cursor c1 is
373: select rule_set_id

Line 370: l_rule_set_id pqh_rule_sets.rule_set_id%type;

366: l_proc varchar2(72) := g_package||'chk_duplicate_rule_set';
367: l_api_updating boolean;
368: l_business_group_id hr_all_organization_units.business_group_id%type;
369: l_rule_set_name pqh_rule_sets_tl.rule_set_name%type;
370: l_rule_set_id pqh_rule_sets.rule_set_id%type;
371: --
372: cursor c1 is
373: select rule_set_id
374: from pqh_rule_sets

Line 374: from pqh_rule_sets

370: l_rule_set_id pqh_rule_sets.rule_set_id%type;
371: --
372: cursor c1 is
373: select rule_set_id
374: from pqh_rule_sets
375: where ((p_organization_id is null and organization_id is null) or
376: (organization_id = p_organization_id))
377: and ((p_organization_structure_id is null and organization_structure_id is null) or
378: (organization_structure_id = p_organization_structure_id))

Line 467: l_rule_set_id PQH_RULE_SETS.rule_set_id%TYPE;

463: p_seeded_rule_flag IN VARCHAR2,
464: p_object_version_number IN NUMBER) IS
465: --
466: l_proc VARCHAR2(72) := g_package||'chk_ins_dup_rule_set';
467: l_rule_set_id PQH_RULE_SETS.rule_set_id%TYPE;
468: l_ref_rule_set_name PQH_RULE_SETS_TL.rule_set_name%TYPE;
469: --
470: CURSOR c1 IS
471: SELECT rule_set_id

Line 468: l_ref_rule_set_name PQH_RULE_SETS_TL.rule_set_name%TYPE;

464: p_object_version_number IN NUMBER) IS
465: --
466: l_proc VARCHAR2(72) := g_package||'chk_ins_dup_rule_set';
467: l_rule_set_id PQH_RULE_SETS.rule_set_id%TYPE;
468: l_ref_rule_set_name PQH_RULE_SETS_TL.rule_set_name%TYPE;
469: --
470: CURSOR c1 IS
471: SELECT rule_set_id
472: FROM pqh_rule_sets

Line 472: FROM pqh_rule_sets

468: l_ref_rule_set_name PQH_RULE_SETS_TL.rule_set_name%TYPE;
469: --
470: CURSOR c1 IS
471: SELECT rule_set_id
472: FROM pqh_rule_sets
473: WHERE rule_set_id <> NVL(p_rule_set_id,-1)
474: AND NVL(business_group_id,-1) = NVL(p_business_group_id,-1)
475: AND NVL(organization_structure_id,-1) = NVL(p_organization_structure_id,-1)
476: AND NVL(starting_organization_id,-1) = NVL(p_starting_organization_id,-1)

Line 667: pqh_rst_shd.constraint_error('PQH_RULE_SETS_FK2');

663: --
664: -- raise error as FK does not relate to PK in per_organization_structures
665: -- table.
666: --
667: pqh_rst_shd.constraint_error('PQH_RULE_SETS_FK2');
668: --
669: end if;
670: --
671: close c1;

Line 1060: From pqh_rule_sets_tl

1056: p_rule_set_name out nocopy varchar2) is
1057: --
1058: Cursor csr_ref is
1059: Select rule_set_name
1060: From pqh_rule_sets_tl
1061: Where rule_set_id = p_rule_set_id;
1062: --
1063: l_proc varchar2(72) := g_package||'get_ref_rule_set_name';
1064: --

Line 1322: pqh_rule_sets b

1318: --
1319: cursor csr_leg_code is
1320: select a.legislation_code
1321: from per_business_groups a,
1322: pqh_rule_sets b
1323: where b.rule_set_id = p_rule_set_id
1324: and a.business_group_id = b.business_group_id;
1325: --
1326: -- Declare local variables