1 PACKAGE per_manage_contracts_pkg AUTHID CURRENT_USER AS
2 /* $Header: pemancon.pkh 115.2 2002/12/06 11:56:23 pkakar noship $ */
3 --
4 --
5 -- Returns a summary flag indicating the type of association between a person and their contracts.
6 --
7 -- 'N' - Person has no contracts.
8 -- 'A' - Person has one or more contracts of which at least one covers an assignment.
9 -- 'P' - Person has one of more contracts and none cover any assignments.
10 --
11 FUNCTION contract_association
12 (p_person_id NUMBER) RETURN VARCHAR2;
13 PRAGMA restrict_references(contract_association, WNPS, WNDS);
14 --
15 --
16 -- Returns the flexfield structures for a business group.
17 --
18 PROCEDURE get_flex_structures
19 (p_business_group_id IN NUMBER
20 ,p_grade_structure IN OUT NOCOPY NUMBER
21 ,p_people_group_structure IN OUT NOCOPY NUMBER
22 ,p_job_structure IN OUT NOCOPY NUMBER
23 ,p_position_structure IN OUT NOCOPY NUMBER);
24 --
25 --
26 -- Calls hr_contract_api.update_contract in date-track CORRECTION mode for all records
27 -- matching supplied contract_id argument, excluding that which matches the object_version_number argument,
28 -- passing only the required arguements plus current values for doc_status and doc_status_date_change.
29 --
30 PROCEDURE update_contracts
31 (p_contract_id IN number
32 ,p_object_version_number IN OUT NOCOPY number
33 ,p_doc_status IN varchar2
34 ,p_doc_status_change_date IN date
35 ,p_exclude_flag IN char);
36 --
37 end per_manage_contracts_pkg;