PACKAGE: APPS.PQH_TENURE_DETAIL

Source

1 PACKAGE pqh_tenure_detail AUTHID CURRENT_USER AS
2 /* $Header: pqhusprn.pkh 115.2 2002/12/03 00:07:32 rpasapul noship $ */
3 
4   managerSeq	NUMBER	:= 1;
5 
6   PROCEDURE  getPersonInfo (
7 		p_person_id 		 IN	NUMBER,
8 		p_employee_number OUT NOCOPY VARCHAR2,
9 		p_full_name	 OUT NOCOPY VARCHAR2,
10 		p_last_name	 OUT NOCOPY VARCHAR2,
11 		p_title		 OUT NOCOPY VARCHAR2,
12 		p_email_addr	 OUT NOCOPY VARCHAR2,
13 		p_start_date	 OUT NOCOPY DATE );
14 
15   PROCEDURE  getPersonTenure (
16 		p_person_id 	 	 IN	NUMBER,
17 		p_tenure_status 	OUT NOCOPY VARCHAR2,
18 		p_date_determine 	OUT NOCOPY VARCHAR2,
19 		p_adjust_date	 	OUT NOCOPY VARCHAR2,
20 		p_remain_years		OUT NOCOPY VARCHAR2,
21 		p_remain_months		OUT NOCOPY VARCHAR2,
22 		p_completed_years 	OUT NOCOPY VARCHAR2,
23 		p_completed_months 	OUT NOCOPY VARCHAR2 );
24 
25   PROCEDURE  getReportBodyText (
26 		p_report_id 	 	 IN	VARCHAR2,
27 		p_body_regards    OUT NOCOPY VARCHAR2,
28 		p_body_text1    OUT NOCOPY VARCHAR2,
29 		p_body_text2    OUT NOCOPY VARCHAR2,
30 		p_body_text3    OUT NOCOPY VARCHAR2,
31 		p_body_text4    OUT NOCOPY VARCHAR2,
32 		p_body_text5    OUT NOCOPY VARCHAR2,
33 		p_body_text6    OUT NOCOPY VARCHAR2,
34 		p_body_text7    OUT NOCOPY VARCHAR2,
35 		p_body_text8  	 OUT NOCOPY VARCHAR2 );
36 
37   PROCEDURE getTenuredCount (
38 		p_supervisor_id		IN	NUMBER,
39 		p_top_level			IN	VARCHAR2,
40 		p_start_academic_dt		IN	DATE,
41 		p_end_academic_dt		IN 	DATE,
42 		p_total_cnt		 OUT NOCOPY NUMBER,
43 		p_tenured_cnt		 OUT NOCOPY NUMBER,
44 		p_tenured_sup_cnt	 OUT NOCOPY NUMBER,
45 		p_tt_cnt			 OUT NOCOPY NUMBER,
46 		p_tt_sup_cnt		 OUT NOCOPY NUMBER,
47 		p_tt_final_yr_cnt	 OUT NOCOPY NUMBER,
48 		p_tt_final_yr_sup_cnt OUT NOCOPY NUMBER,
49 		p_ten_cur_yr_cnt	 OUT NOCOPY NUMBER,
50 		p_ten_cur_yr_sup_cnt OUT NOCOPY NUMBER,
51 		p_te_cur_yr_cnt	 OUT NOCOPY NUMBER,
52 		p_te_cur_yr_sup_cnt	 OUT NOCOPY NUMBER,
53 		p_td_cur_yr_cnt	 OUT NOCOPY  NUMBER,
54 		p_td_cur_yr_sup_cnt	 OUT NOCOPY NUMBER	);
55 
56   FUNCTION getPersonAddress (
57 		p_person_id		 IN	NUMBER,
58 		p_bgroup_id		 IN	NUMBER ) RETURN VARCHAR2 ;
59 
60   FUNCTION getPersonSupervisor (
61 		p_person_id 		 IN 	NUMBER ) RETURN NUMBER;
62 
63   FUNCTION getPersonRank (
64 		p_person_id 		 IN 	NUMBER ) RETURN VARCHAR2;
65 
66   FUNCTION getPersonJobPosition (
67 		p_person_id		IN 	NUMBER ) RETURN VARCHAR2;
68 
69   FUNCTION  getSupStatusCount (
70 		p_supervisor_id          IN NUMBER,
71 		p_tenure_status          IN VARCHAR2,
72 		p_effective_date		IN DATE	) RETURN NUMBER;
73 
74   FUNCTION  getPeriodStatusCount (
75 		p_supervisor_id          IN NUMBER,
76 		p_tenure_status          IN VARCHAR2,
77 		p_start_date			IN DATE,
78 		p_end_date			IN DATE	) RETURN NUMBER;
79 
80   FUNCTION  getStatusCount (
81 		p_supervisor_id          IN NUMBER,
82 		p_tenure_status          IN VARCHAR2 ) RETURN NUMBER;
83 
84   FUNCTION getManagerSequence  RETURN NUMBER;
85 
86 END pqh_tenure_detail;