PACKAGE: APPS.IGW_GR_REPORT_PROCESSING

Source

1 PACKAGE IGW_GR_REPORT_PROCESSING as
2 -- $Header: igwgrrpprs.pls 120.0 2005/06/16 23:01:35 vmedikon ship $
3 
4   G_PKG_NAME CONSTANT VARCHAR2(30) := 'IGW_REPORT_PROCESSING';
5 
6   G_INSTALLATION_MODE CONSTANT VARCHAR2(30) := fnd_profile.value_wnps('IGW_PROPOSAL_INSTALLATION_MODE');
7 
8  FUNCTION get_last_first_middle_name(p_party_id      in        number,
9                                                         p_proposal_id     in     number) return varchar2;
10 
11  FUNCTION get_job_title(p_party_id      in        number,
12                                     p_proposal_id     in     number) return varchar2;
13 
14  FUNCTION get_person_organization(p_party_id      in        number) return varchar2;
15 
16  FUNCTION get_phone_number(p_party_id      in        number,
17                                               p_proposal_id     in     number) return varchar2;
18 
19  FUNCTION get_fax_number(p_party_id      in        number,
20                                          p_proposal_id      in      number) return varchar2;
21 
22  FUNCTION get_email_address(p_party_id      in        number,
23                                              p_proposal_id       in     number) return varchar2;
24 
25   FUNCTION get_person_address(p_party_id  	in 	number,
26                                                 p_proposal_id      in        number) return  varchar2;
27 
28 FUNCTION does_special_research (p_proposal_id      in          number,
29                                                    p_special_review_code    in     number) return  varchar2;
30 
31 FUNCTION animal_approval_date (p_proposal_id      in          number) return  date;
32 
33 FUNCTION format_address
34          ( i_address_line1 varchar2,
35            i_address_line2 varchar2,
36            i_address_line3 varchar2,
37            i_town_or_city  varchar2,
38            i_region_1      varchar2,
39            i_region_2      varchar2,
40            i_region_3      varchar2,
41            i_postal_code   varchar2 ) RETURN varchar2;
42 
43 FUNCTION format_address_multiline
44          ( i_address_line1 varchar2,
45            i_address_line2 varchar2,
46            i_address_line3 varchar2,
47            i_town_or_city  varchar2,
48            i_region_1      varchar2,
49            i_region_2      varchar2,
50            i_region_3      varchar2,
51            i_postal_code   varchar2 ) RETURN varchar2;
52 
53 FUNCTION get_category_period_amount(p_proposal_id NUMBER,
54 						p_budget_category_code VARCHAR2,
55 						p_budget_period_id NUMBER) RETURN NUMBER;
56 
57 FUNCTION get_category_period_desc(p_proposal_id NUMBER,
58 				       p_budget_category_code VARCHAR2,
59 			                   p_budget_period_id NUMBER)  RETURN VARCHAR2;
60 
61 FUNCTION get_period_distr_dc(p_proposal_id NUMBER,
62 		                     p_budget_period_id NUMBER) return number;
63 
64 FUNCTION get_period_distr_ic(p_proposal_id NUMBER,
65 		                     p_budget_period_id NUMBER) return number;
66 
67 FUNCTION get_total_distr_dc(p_proposal_id NUMBER) return number;
68 
69 FUNCTION get_total_distr_ic(p_proposal_id NUMBER) return number;
70 
71 FUNCTION get_salary_requested(p_proposal_id 		NUMBER,
72 				p_party_id 		NUMBER,
73 		                        p_budget_period_id 	NUMBER) RETURN NUMBER;
74 
75 FUNCTION get_employee_benefits(p_proposal_id 		NUMBER,
76 				 p_party_id 		NUMBER,
77 		                         p_budget_period_id 	NUMBER) RETURN NUMBER;
78 
79 FUNCTION get_budget_percent_effort(p_proposal_id 		NUMBER,
80 				      p_party_id 			NUMBER,
81 		                              p_budget_period_id 		NUMBER) RETURN NUMBER;
82 
83 FUNCTION get_budget_justification(p_proposal_id NUMBER,
84 				  p_budget_category_code VARCHAR2)  RETURN CLOB;
85 
86 
87 FUNCTION get_other_support_commitment(p_prop_person_support_id      NUMBER)  RETURN VARCHAR2;
88 
89 FUNCTION get_person_effort(p_proposal_id      in         number,
90                                           p_party_id           in         number) RETURN NUMBER;
91  /*
92  FUNCTION  get_org_party_name(p_party_id in number, p_org_id in number) RETURN VARCHAR2;
93  pragma restrict_references(get_org_party_name, wnds, wnps);
94 */
95 
96 FUNCTION get_person_appt(p_proposal_id      in         number,
97                          p_party_id         in         number) RETURN NUMBER;
98 
99 END IGW_GR_REPORT_PROCESSING;