DBA Data[Home] [Help]

APPS.GHR_PDI_BUS dependencies on GHR_POSITION_DESCRIPTIONS

Line 13: Procedure chk_date_to(p_position_description_id IN ghr_position_descriptions.position_description_id%TYPE,

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:

Line 42: ghr_position_descriptions.position_description_id%TYPE,

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

Line 43: p_category IN ghr_position_descriptions.category%TYPE,

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:

Line 116: ghr_position_descriptions.position_description_id%TYPE,

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:

Line 117: p_flsa IN ghr_position_descriptions.flsa%TYPE,

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

Line 193: ghr_position_descriptions.position_description_id%TYPE,

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:

Line 194: p_financial_statement IN ghr_position_descriptions.financial_statement%TYPE,

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

Line 271: ghr_position_descriptions.position_description_id%TYPE,

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:

Line 272: p_sub_to_ia_action IN ghr_position_descriptions.subject_to_ia_action %TYPE,

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

Line 351: ghr_position_descriptions.position_description_id%TYPE,

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

Line 352: p_position_status IN ghr_position_descriptions.position_status%TYPE,

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';

Line 428: ghr_position_descriptions.position_description_id%TYPE,

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:

Line 429: p_position_is IN ghr_position_descriptions.position_is%TYPE,

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

Line 506: ghr_position_descriptions.position_description_id%TYPE,

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:

Line 507: p_position_sensitivity IN ghr_position_descriptions.position_sensitivity%TYPE,

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

Line 585: ghr_position_descriptions.position_description_id%TYPE,

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

Line 586: p_competitive_level IN ghr_position_descriptions.competitive_level%TYPE,

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:

Line 661: ghr_position_descriptions.position_description_id%TYPE,

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:

Line 662: p_career_ladder IN ghr_position_descriptions.career_ladder%TYPE,

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:

Line 743: ghr_position_descriptions.position_description_id%TYPE,

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:

Line 744: p_routing_group_id IN ghr_position_descriptions.routing_group_id%TYPE,

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