1 PACKAGE BODY IGW_GR_REPORT_PROCESSING as
2 -- $Header: igwgrrpprb.pls 120.1 2005/09/12 22:01:18 ashkumar ship $
3
4 --G_INSTALLATION_MODE VARCHAR2(30) := fnd_profile.value_wnps('IGW_PROPOSAL_INSTALLATION_MODE');
5 --------------------------------------------------------------------------------------------------
6 FUNCTION get_last_first_middle_name(p_party_id in number,
7 p_proposal_id in number) return varchar2 is
8 begin
9 return null;
10 end get_last_first_middle_name;
11 --------------------------------------------------------------
12 FUNCTION get_job_title(p_party_id in number,
13 p_proposal_id in number) return varchar2 is
14 begin
15 return null;
16 end get_job_title;
17
18 --------------------------------------------------------------
19 FUNCTION get_person_organization(p_party_id in number) return varchar2 is
20 begin
21 return null;
22 end get_person_organization;
23 -------------------------------------------------------------------
24 FUNCTION get_phone_number(p_party_id in number,
25 p_proposal_id in number) return varchar2 is
26 begin
27 return null;
28 end get_phone_number;
29 ---------------------------------------------------------------------
30
31 FUNCTION get_fax_number(p_party_id in number,
32 p_proposal_id in number) return varchar2 is
33 begin
34 return null;
35 end get_fax_number;
36 ---------------------------------------------------------------------
37 FUNCTION get_email_address(p_party_id in number,
38 p_proposal_id in number) return varchar2 is
39 begin
40 return null;
41 end get_email_address;
42 -----------------------------------------------------------------------
43 FUNCTION get_person_address(p_party_id in number,
44 p_proposal_id in number) return varchar2 is
45 begin
46 return null;
47 end get_person_address;
48 ------------------------------------------------------------------
49 FUNCTION does_special_research (p_proposal_id in number,
50 p_special_review_code in number) return varchar2 is
51 begin
52 return null;
53 end does_special_research;
54 --------------------------------------------------------------------------
55 FUNCTION animal_approval_date (p_proposal_id in number) return date is
56 begin
57 return null;
58 end animal_approval_date;
59 ----------------------------------------------------------------------------
60 FUNCTION format_address
61 ( i_address_line1 varchar2,
62 i_address_line2 varchar2,
63 i_address_line3 varchar2,
64 i_town_or_city varchar2,
65 i_region_1 varchar2,
66 i_region_2 varchar2,
67 i_region_3 varchar2,
68 i_postal_code varchar2 )
69 RETURN varchar2 IS
70 BEGIN
71 return null;
72 END;
73
74 FUNCTION format_address_multiline
75 ( i_address_line1 varchar2,
76 i_address_line2 varchar2,
77 i_address_line3 varchar2,
78 i_town_or_city varchar2,
79 i_region_1 varchar2,
80 i_region_2 varchar2,
81 i_region_3 varchar2,
82 i_postal_code varchar2 )
83 RETURN varchar2 IS
84 BEGIN
85 return null;
86 END;
87
88 FUNCTION get_category_period_amount(p_proposal_id NUMBER,
89 p_budget_category_code VARCHAR2,
90 p_budget_period_id NUMBER)
91 RETURN NUMBER IS
92 BEGIN
93 return null;
94 END get_category_period_amount;
95
96 ---------------------------------------------------------------------------
97 FUNCTION get_category_period_desc(p_proposal_id NUMBER,
98 p_budget_category_code VARCHAR2,
99 p_budget_period_id NUMBER)
100 RETURN VARCHAR2 IS
101 begin
102 return null;
103 end get_category_period_desc;
104
105 ---------------------------------------------------------------------
106 FUNCTION get_period_distr_dc(p_proposal_id NUMBER,
107 p_budget_period_id NUMBER) return number is
108 begin
109 return null;
110 end get_period_distr_dc;
111
112 --------------------------------------------------------------------
113 FUNCTION get_total_distr_dc(p_proposal_id NUMBER) return number is
114 begin
115 return null;
116 end get_total_distr_dc;
117
118 --------------------------------------------------------------------
119 FUNCTION get_total_distr_ic(p_proposal_id NUMBER) return number is
120 begin
121 return null;
122 end get_total_distr_ic;
123 -----------------------------------------------------------------
124 FUNCTION get_period_distr_ic(p_proposal_id NUMBER,
125 p_budget_period_id NUMBER) return number is
126 begin
127 return null;
128 end get_period_distr_ic;
129 --------------------------------------------------------------------
130 FUNCTION get_salary_requested(p_proposal_id NUMBER,
131 p_party_id NUMBER,
132 p_budget_period_id NUMBER) RETURN NUMBER IS
133 begin
134 return null;
135 end get_salary_requested;
136
137 --------------------------------------------------------------
138 FUNCTION get_employee_benefits(p_proposal_id NUMBER,
139 p_party_id NUMBER,
140 p_budget_period_id NUMBER) RETURN NUMBER IS
141 begin
142 return null;
143 end get_employee_benefits;
144
145 -------------------------------------------------------
146 FUNCTION get_budget_percent_effort(p_proposal_id NUMBER,
147 p_party_id NUMBER,
148 p_budget_period_id NUMBER) RETURN NUMBER IS
149 begin
150 return null;
151 end get_budget_percent_effort;
152 ------------------------------------------------------
153 FUNCTION get_budget_justification(p_proposal_id NUMBER,
154 p_budget_category_code VARCHAR2)
155 RETURN CLOB IS
156 BEGIN
157 RETURN null;
158 END get_budget_justification;
159
160 ---------------------------------------------------------------------------
161 FUNCTION get_other_support_commitment(p_prop_person_support_id NUMBER)
162 RETURN VARCHAR2 IS
163 begin
164 return null;
165 end get_other_support_commitment;
166 -----------------------------------------------------------------------------------
167 FUNCTION get_person_effort(p_proposal_id in number,
168 p_party_id in number)
169 RETURN NUMBER IS
170 begin
171 return null;
172 end get_person_effort;
173
174 ------------------------------------------------------------------------------------
175 FUNCTION get_person_appt(p_proposal_id in number,
176 p_party_id in number)
177 RETURN NUMBER IS
178 BEGIN
179 return null;
180 END get_person_appt;
181 END IGW_GR_REPORT_PROCESSING;