1 package PA_AGREEMENT_CORE AUTHID CURRENT_USER as
2 /*$Header: PAAFAGCS.pls 120.2 2007/02/07 10:43:03 rgandhi ship $*/
3
4 -- FUNCTION check_multi_customer check weather project is Multi-Customer or
5 -- Single-Customer
6
7 FUNCTION check_multi_customers
8 ( p_project_id IN NUMBER
9 ) RETURN VARCHAR2 ;
10
11
12 -- FUNCTION check_contribution will ensure that the Customer Contribution
13 -- is exactly 100 % provided agreement is a template agreement.
14
15
16 FUNCTION check_contribution
17 ( p_agreement_id IN NUMBER
18 ) RETURN VARCHAR2 ;
19
20
21 -- FUNCTION check_valid_customer check weather Customer is valid or not
22
23 FUNCTION check_valid_customer
24 ( p_customer_id IN NUMBER
25 ) RETURN VARCHAR2 ;
26
27 -- FUNCTION check_valid_type check weather Agreement type is valid or not
28
29 FUNCTION check_valid_type
30 ( p_agreement_type IN VARCHAR2
31 ) RETURN VARCHAR2;
32
33 -- FUNCTION check_invoice_exists check weather invoices exists for given Agreement.
34
35 FUNCTION check_invoice_exists
36 ( p_agreement_id IN NUMBER
37 ) RETURN VARCHAR2;
38
39 -- FUNCTION check_valid_term_id check weather term_id is active And valid or not
40
41 FUNCTION check_valid_term_id
42 ( p_term_id IN NUMBER
43 ) RETURN VARCHAR2;
44
45 -- FUNCTION check_valid_owned_by_person_id check weather check_valid_owned_by_person_id is valid or not
46
47 FUNCTION check_valid_owned_by_person_id
48 ( p_owned_by_person_id IN NUMBER
49 ) RETURN VARCHAR2;
50
51 -- FUNCTION check_unique_agreement check weather agreement_num, agreement_type and customer
52 -- are of unique combination
53
54 FUNCTION check_unique_agreement
55 ( p_agreement_num IN VARCHAR2
56 ,p_agreement_type IN VARCHAR2
57 ,p_customer_id IN NUMBER
58 )RETURN VARCHAR2;
59
60 FUNCTION validate_agreement_amount
61 ( p_agreement_id IN NUMBER
62 ,p_amount IN NUMBER
63 ) RETURN VARCHAR2;
64
65 FUNCTION check_revenue_limit
66 ( p_agreement_id IN NUMBER
67 ) RETURN VARCHAR2;
68
69 FUNCTION check_budget_type
70 ( p_funding_id IN NUMBER
71 ) RETURN VARCHAR2;
72
73 FUNCTION get_agreement_id
74 ( p_funding_id IN NUMBER
75 ,p_funding_reference IN VARCHAR2
76 ) RETURN NUMBER;
77
78 FUNCTION get_customer_id
79 ( p_funding_id IN NUMBER
80 ,p_funding_reference IN VARCHAR2
81 ) RETURN NUMBER;
82
83 FUNCTION get_project_id
84 ( p_funding_id IN NUMBER
85 ,p_funding_reference IN VARCHAR2
86 ) RETURN NUMBER;
87
88 FUNCTION get_task_id
89 ( p_funding_id IN NUMBER
90 ,p_funding_reference IN VARCHAR2
91 ) RETURN NUMBER;
92
93
94 FUNCTION check_add_update
95 ( p_funding_id IN NUMBER
96 ,p_funding_reference IN VARCHAR2
97 ) RETURN VARCHAR2;
98
99 FUNCTION check_valid_agreement_ref
100 (p_agreement_reference IN VARCHAR2
101 )RETURN VARCHAR2 ;
102
103 FUNCTION check_valid_agreement_id
104 (p_agreement_id IN NUMBER
105 )RETURN VARCHAR2 ;
106
107 FUNCTION check_valid_funding_ref
108 (p_funding_reference IN VARCHAR2
109 ,p_agreement_id IN NUMBER
110 )RETURN VARCHAR2 ;
111
112 FUNCTION check_valid_funding_id
113 (p_agreement_id IN NUMBER
114 ,p_funding_id IN NUMBER
115 )RETURN VARCHAR2 ;
116
117
118 PROCEDURE create_agreement(
119 p_Rowid IN OUT NOCOPY VARCHAR2,/*File.sql.39*/
120 p_Agreement_Id IN OUT NOCOPY NUMBER,/*File.sql.39*/
121 p_Customer_Id IN NUMBER,
122 p_Agreement_Num IN VARCHAR2,
123 p_Agreement_Type IN VARCHAR2,
124 p_Last_Update_Date IN DATE,
125 p_Last_Updated_By IN NUMBER,
126 p_Creation_Date IN DATE,
127 p_Created_By IN NUMBER,
128 p_Last_Update_Login IN NUMBER,
129 p_Owned_By_Person_Id IN NUMBER,
130 p_Term_Id IN NUMBER,
131 p_Revenue_Limit_Flag IN VARCHAR2,
132 p_Amount IN NUMBER,
133 p_Description IN VARCHAR2,
134 p_Expiration_Date IN DATE,
135 p_Attribute_Category IN VARCHAR2,
136 p_Attribute1 IN VARCHAR2,
137 p_Attribute2 IN VARCHAR2,
138 p_Attribute3 IN VARCHAR2,
139 p_Attribute4 IN VARCHAR2,
140 p_Attribute5 IN VARCHAR2,
141 p_Attribute6 IN VARCHAR2,
142 p_Attribute7 IN VARCHAR2,
143 p_Attribute8 IN VARCHAR2,
144 p_Attribute9 IN VARCHAR2,
145 p_Attribute10 IN VARCHAR2,
146 p_Template_Flag IN VARCHAR2,
147 p_pm_agreement_reference IN VARCHAR2,
148 p_pm_product_code IN VARCHAR2,
149 p_agreement_currency_code IN VARCHAR2 DEFAULT NULL,
150 p_owning_organization_id IN NUMBER DEFAULT NULL,
151 p_invoice_limit_flag IN VARCHAR2 DEFAULT NULL,
152 /*Federal*/
153 p_customer_order_number IN VARCHAR2 DEFAULT NULL,
154 p_advance_required IN VARCHAR2 DEFAULT NULL,
155 p_start_date IN DATE DEFAULT NULL,
156 p_billing_sequence IN NUMBER DEFAULT NULL,
157 p_line_of_account IN VARCHAR2 DEFAULT NULL,
158 p_Attribute11 IN VARCHAR2 DEFAULT NULL,
159 p_Attribute12 IN VARCHAR2 DEFAULT NULL,
160 p_Attribute13 IN VARCHAR2 DEFAULT NULL,
161 p_Attribute14 IN VARCHAR2 DEFAULT NULL,
162 p_Attribute15 IN VARCHAR2 DEFAULT NULL,
163 p_Attribute16 IN VARCHAR2 DEFAULT NULL,
164 p_Attribute17 IN VARCHAR2 DEFAULT NULL,
165 p_Attribute18 IN VARCHAR2 DEFAULT NULL,
166 p_Attribute19 IN VARCHAR2 DEFAULT NULL,
167 p_Attribute20 IN VARCHAR2 DEFAULT NULL,
168 p_Attribute21 IN VARCHAR2 DEFAULT NULL,
169 p_Attribute22 IN VARCHAR2 DEFAULT NULL,
170 p_Attribute23 IN VARCHAR2 DEFAULT NULL,
171 p_Attribute24 IN VARCHAR2 DEFAULT NULL,
172 p_Attribute25 IN VARCHAR2 DEFAULT NULL
173
174 );
175
176 PROCEDURE Lock_agreement(p_Agreement_Id IN NUMBER );
177
178 PROCEDURE Update_agreement(
179 p_Agreement_Id NUMBER,
180 p_Customer_Id NUMBER,
181 p_Agreement_Num VARCHAR2,
182 p_Agreement_Type VARCHAR2,
183 p_Last_Update_Date DATE,
184 p_Last_Updated_By NUMBER,
185 p_Last_Update_Login NUMBER,
186 p_Owned_By_Person_Id NUMBER,
187 p_Term_Id NUMBER,
188 p_Revenue_Limit_Flag VARCHAR2,
189 p_Amount NUMBER,
190 p_Description VARCHAR2,
191 p_Expiration_Date DATE,
192 p_Attribute_Category VARCHAR2,
193 p_Attribute1 VARCHAR2,
194 p_Attribute2 VARCHAR2,
195 p_Attribute3 VARCHAR2,
196 p_Attribute4 VARCHAR2,
197 p_Attribute5 VARCHAR2,
198 p_Attribute6 VARCHAR2,
199 p_Attribute7 VARCHAR2,
200 p_Attribute8 VARCHAR2,
201 p_Attribute9 VARCHAR2,
202 p_Attribute10 VARCHAR2,
203 p_Template_Flag VARCHAR2,
204 p_pm_agreement_reference VARCHAR2,
205 p_pm_product_code VARCHAR2,
206 p_agreement_currency_code IN VARCHAR2 DEFAULT NULL,
207 p_owning_organization_id IN NUMBER DEFAULT NULL,
208 p_invoice_limit_flag IN VARCHAR2 DEFAULT NULL,
209 /*Federal*/
210 p_customer_order_number IN VARCHAR2 DEFAULT NULL,
211 p_advance_required IN VARCHAR2 DEFAULT NULL,
212 p_start_date IN DATE DEFAULT NULL,
213 p_billing_sequence IN NUMBER DEFAULT NULL,
214 p_line_of_account IN VARCHAR2 DEFAULT NULL,
215 p_Attribute11 IN VARCHAR2 DEFAULT NULL,
219 p_Attribute15 IN VARCHAR2 DEFAULT NULL,
216 p_Attribute12 IN VARCHAR2 DEFAULT NULL,
217 p_Attribute13 IN VARCHAR2 DEFAULT NULL,
218 p_Attribute14 IN VARCHAR2 DEFAULT NULL,
220 p_Attribute16 IN VARCHAR2 DEFAULT NULL,
221 p_Attribute17 IN VARCHAR2 DEFAULT NULL,
222 p_Attribute18 IN VARCHAR2 DEFAULT NULL,
223 p_Attribute19 IN VARCHAR2 DEFAULT NULL,
224 p_Attribute20 IN VARCHAR2 DEFAULT NULL,
225 p_Attribute21 IN VARCHAR2 DEFAULT NULL,
226 p_Attribute22 IN VARCHAR2 DEFAULT NULL,
227 p_Attribute23 IN VARCHAR2 DEFAULT NULL,
228 p_Attribute24 IN VARCHAR2 DEFAULT NULL,
229 p_Attribute25 IN VARCHAR2 DEFAULT NULL
230 );
231
232 PROCEDURE Delete_agreement(p_agreement_id IN NUMBER );
233
234 FUNCTION get_agr_curr_code (
235 p_agreement_id IN NUMBER) RETURN VARCHAR2;
236 FUNCTION check_valid_owning_orgn_id (
237 p_owning_organization_id IN NUMBER) RETURN VARCHAR2;
238 FUNCTION check_valid_agr_curr_code(
239 p_agreement_currency_code IN VARCHAR2) RETURN VARCHAR2;
240 FUNCTION check_invoice_limit (
241 p_agreement_id IN NUMBER) RETURN VARCHAR2;
242
243 end PA_AGREEMENT_CORE;