PACKAGE: APPS.IGW_GR_PERSONNEL

Source

1 package IGW_GR_PERSONNEL as
2 /* $Header: igwgrpersonnels.pls 120.0 2005/06/16 23:01:42 vmedikon ship $ */
3 
4 ----------------------------------------  PERSONNEL GENERAL ------------------------------------------
5 FUNCTION MIN_PERSONNEL_START_DATE (P_PROPOSAL_ID 	IN 	NUMBER,
6 				   P_PERSON_PARTY_ID	IN	NUMBER) RETURN DATE;
7 
8 FUNCTION MAX_PERSONNEL_END_DATE (P_PROPOSAL_ID 	IN 	NUMBER,
9 				   P_PERSON_PARTY_ID	IN	NUMBER) RETURN DATE;
10 
11  ---------------------------------------------------------------------------------------------------------
12 FUNCTION GET_SPONSOR_NAME (p_sponsor_id	number) return varchar2;
13 
14 
15 ---------------------------------------------------------------------------------------
16 FUNCTION GET_PERSON_NAME (p_person_party_id number) return varchar2;
17 
18 ---------------------------------------------------------------------------------------------------------
19 FUNCTION GET_MAJOR_GOALS (p_proposal_id   NUMBER) RETURN VARCHAR2;
20 
21 --------------------------------------------------------------------------------------
22 PROCEDURE POPULATE_BIO_TABLES (	p_init_msg_list     	in    	varchar2,
23  			                p_commit              	in    	varchar2,
24  			       		p_validate_only     	in    	varchar2,
25 			       		p_proposal_id       	in    	number,
26 			       		p_party_id          		in    	number,
27 			       		x_return_status	   	out 	NOCOPY   varchar2,
28 			       		x_msg_count         	out 	NOCOPY   number,
29  			       		x_msg_data          	out 	NOCOPY   varchar2);
30 
31 FUNCTION GET_FORMATTED_ADDRESS (P_PARTY_ID      NUMBER) RETURN VARCHAR2;
32 
33 PROCEDURE add_other_support_commitments (
34       p_init_msg_list                IN VARCHAR2,
35       p_validate_only                IN VARCHAR2,
36       p_commit                       IN VARCHAR2,
37       p_prop_person_support_id       IN NUMBER,
38       p_proposal_id                  IN NUMBER,
39       p_person_party_id              IN NUMBER,
40       x_return_status                OUT NOCOPY VARCHAR2,
41       x_msg_count                    OUT NOCOPY NUMBER,
42       x_msg_data                     OUT NOCOPY VARCHAR2);
43 
44 -----------------------------------------------------------------------
45 PROCEDURE delete_personnel_related_data(
46       p_init_msg_list                IN 		VARCHAR2  ,
47       p_commit                       IN 		VARCHAR2  ,
48       p_proposal_id                IN 		NUMBER,
49       p_person_party_id          IN 		NUMBER,
50       x_return_status               OUT 	NOCOPY VARCHAR2,
51       x_msg_count                  OUT 	NOCOPY NUMBER,
52       x_msg_data                    OUT 	NOCOPY VARCHAR2);
53 END  IGW_GR_PERSONNEL;