9:
10: --
11: -----------------------------
12: --
13: Procedure chk_date_to(p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,
14: p_date_from IN DATE,
15: p_date_to IN DATE)
16: is
17:
38: --
39: -----------------------------
40: --
41: Procedure chk_category(p_position_description_id IN
42: ghr_position_descriptions.position_description_id%TYPE,
43: p_category IN ghr_position_descriptions.category%TYPE,
44: p_effective_date IN DATE,
45: p_object_version_number IN number)
46: IS
39: -----------------------------
40: --
41: Procedure chk_category(p_position_description_id IN
42: ghr_position_descriptions.position_description_id%TYPE,
43: p_category IN ghr_position_descriptions.category%TYPE,
44: p_effective_date IN DATE,
45: p_object_version_number IN number)
46: IS
47:
112: --
113: -----------------------------
114: --
115: Procedure chk_flsa(p_position_description_id IN
116: ghr_position_descriptions.position_description_id%TYPE,
117: p_flsa IN ghr_position_descriptions.flsa%TYPE,
118: p_effective_date IN DATE,
119: p_object_version_number IN number)
120:
113: -----------------------------
114: --
115: Procedure chk_flsa(p_position_description_id IN
116: ghr_position_descriptions.position_description_id%TYPE,
117: p_flsa IN ghr_position_descriptions.flsa%TYPE,
118: p_effective_date IN DATE,
119: p_object_version_number IN number)
120:
121: IS
189: -----------------------------
190: --
191:
192: Procedure chk_financial_statement(p_position_description_id IN
193: ghr_position_descriptions.position_description_id%TYPE,
194: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE,
195: p_effective_date IN date,
196: p_object_version_number IN number)
197:
190: --
191:
192: Procedure chk_financial_statement(p_position_description_id IN
193: ghr_position_descriptions.position_description_id%TYPE,
194: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE,
195: p_effective_date IN date,
196: p_object_version_number IN number)
197:
198: IS
267: -------------------------------< chk_subject_to_ia_action>---------------------
268: --
269:
270: Procedure chk_subject_to_ia_action (p_position_description_id IN
271: ghr_position_descriptions.position_description_id%TYPE,
272: p_sub_to_ia_action IN ghr_position_descriptions.subject_to_ia_action %TYPE,
273: p_effective_date IN date,
274: p_object_version_number IN number)
275:
268: --
269:
270: Procedure chk_subject_to_ia_action (p_position_description_id IN
271: ghr_position_descriptions.position_description_id%TYPE,
272: p_sub_to_ia_action IN ghr_position_descriptions.subject_to_ia_action %TYPE,
273: p_effective_date IN date,
274: p_object_version_number IN number)
275:
276: IS
347: ---------------------------------
348: --
349:
350: Procedure chk_position_status (p_position_description_id IN
351: ghr_position_descriptions.position_description_id%TYPE,
352: p_position_status IN ghr_position_descriptions.position_status%TYPE,
353: p_effective_date IN date,
354: p_object_version_number IN number)
355: IS
348: --
349:
350: Procedure chk_position_status (p_position_description_id IN
351: ghr_position_descriptions.position_description_id%TYPE,
352: p_position_status IN ghr_position_descriptions.position_status%TYPE,
353: p_effective_date IN date,
354: p_object_version_number IN number)
355: IS
356: l_proc varchar2(72) := g_package||'chk_position_status';
424: -----------------------------------
425: --
426:
427: Procedure chk_position_is (p_position_description_id IN
428: ghr_position_descriptions.position_description_id%TYPE,
429: p_position_is IN ghr_position_descriptions.position_is%TYPE,
430: p_effective_date IN date,
431: p_object_version_number IN number)
432:
425: --
426:
427: Procedure chk_position_is (p_position_description_id IN
428: ghr_position_descriptions.position_description_id%TYPE,
429: p_position_is IN ghr_position_descriptions.position_is%TYPE,
430: p_effective_date IN date,
431: p_object_version_number IN number)
432:
433: IS
502: -----------------------------
503:
504:
505: Procedure chk_position_sensitivity(p_position_description_id IN
506: ghr_position_descriptions.position_description_id%TYPE,
507: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE,
508: p_effective_date IN date,
509: p_object_version_number IN number)
510:
503:
504:
505: Procedure chk_position_sensitivity(p_position_description_id IN
506: ghr_position_descriptions.position_description_id%TYPE,
507: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE,
508: p_effective_date IN date,
509: p_object_version_number IN number)
510:
511: IS
581: -----------------------------------
582: --
583:
584: Procedure chk_competitive_level(p_position_description_id IN
585: ghr_position_descriptions.position_description_id%TYPE,
586: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE,
587: p_effective_date IN date,
588: p_object_version_number IN number)
589: IS
582: --
583:
584: Procedure chk_competitive_level(p_position_description_id IN
585: ghr_position_descriptions.position_description_id%TYPE,
586: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE,
587: p_effective_date IN date,
588: p_object_version_number IN number)
589: IS
590:
657: ------------------------------------
658: --
659:
660: Procedure chk_career_ladder(p_position_description_id IN
661: ghr_position_descriptions.position_description_id%TYPE,
662: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE,
663: p_effective_date IN date,
664: p_object_version_number IN number)
665:
658: --
659:
660: Procedure chk_career_ladder(p_position_description_id IN
661: ghr_position_descriptions.position_description_id%TYPE,
662: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE,
663: p_effective_date IN date,
664: p_object_version_number IN number)
665:
666:
739: ------------------------------------
740: --
741:
742: Procedure chk_routing_group_id(p_position_description_id IN
743: ghr_position_descriptions.position_description_id%TYPE,
744: p_routing_group_id IN ghr_position_descriptions.routing_group_id%TYPE,
745: p_effective_date IN date,
746: p_object_version_number IN number)
747:
740: --
741:
742: Procedure chk_routing_group_id(p_position_description_id IN
743: ghr_position_descriptions.position_description_id%TYPE,
744: p_routing_group_id IN ghr_position_descriptions.routing_group_id%TYPE,
745: p_effective_date IN date,
746: p_object_version_number IN number)
747:
748: IS