1 PACKAGE PQH_FR_ASSIGNMENT_CHK AUTHID CURRENT_USER AS
2 /* $Header: pqasgchk.pkh 120.0 2005/05/29 01:25 appldev noship $ */
3 --
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 -- Purpose: Briefly explain the functionality of the package
8 --
9 -- MODIFICATION HISTORY
10 -- Person Date Comments
11 -- --------- ------ ------------------------------------------
12 -- Enter package declarations as shown below
13
14 procedure chk_Identifier(p_identifier in Varchar2);
15
16 procedure chk_percent_affected(p_percent_effected in varchar2, p_person_id in number, p_effective_date in date, p_assignment_id number default Null);
17
18 procedure chk_position(p_position_id in Number,
19 p_person_id in Number,
20 p_effective_date in DATE);
21
22 procedure chk_tot_percent_affected(p_percent_effected in varchar2,
23 p_person_id in number,
24 p_effective_date in date,
25 p_assignment_id number default Null);
26
27 procedure chk_type(p_type in varchar2,
28 p_person_id in Number,
29 p_effective_date in DATE,
30 p_position_id in Number);
31
32 procedure chk_Primary_affectation(p_person_id in number,
33 p_effective_date in date,
34 p_admin_career_id in number);
35
36 procedure chk_situation(p_person_id in Number,
37 p_effective_date in DATE);
38
39
40 END PQH_FR_ASSIGNMENT_CHK;