1 PACKAGE pn_term_templates_pkg AS
2 -- $Header: PNTTRMTS.pls 120.2 2005/07/26 05:17:27 appldev ship $
3
4 /*============================================================================+
5 | Copyright (c) 2001 Oracle Corporation
6 | Redwood Shores, California, USA
7 | All rights reserved.
8 | DESCRIPTION
9 |
10 | These procedures consist are used a table handlers for the PN_TERM_TEMPLATES table.
11 | They include:
12 | INSERT_ROW - insert a row into PN_TERM_TEMPLATES.
13 | DELETE_ROW - deletes a row from PN_TERM_TEMPLATES.
14 | UPDATE_ROW - updates a row from PN_TERM_TEMPLATES.
15 | LOCKS_ROW - will check if a row has been modified since being queried by form.
16 |
17 |
18 | HISTORY
19 | 08-MAY-01 jbreyes o Created
20 | 13-DEC-01 Mrinal Misra o Added dbdrv command.
21 | 13-JUN-02 Daniel Thota o Added x_org_id as an IN parameter in the
22 | INSERT_ROW check_unq_term_template
23 | procedures for Shared Srevices Project
24 | 05-AUG-02 Mrinal Misra o Added x_location_id parameter.
25 | 19-AUG-02 Mrinal Misra o Added check file command.
26 | 18-MAY-04 ftanudja o Add logic for term template type. 3539408.
27 | 05-Jul-05 sdmahesh o overloaded delete_row proc to take PK as parameter
28 +===========================================================================*/
29 /**** SPECIFICATIONS ****/
30 ------------------------------------------------------------------------
31 -- PROCEDURE : INSERT_ROW
32 ------------------------------------------------------------------------
33 PROCEDURE insert_row (
34 x_rowid IN OUT NOCOPY VARCHAR2
35 ,x_term_template_id IN OUT NOCOPY NUMBER
36 ,x_name IN VARCHAR2
37 ,x_set_of_books_id IN NUMBER
38 ,x_currency_code IN VARCHAR2
39 ,x_last_update_date IN DATE
40 ,x_last_updated_by IN NUMBER
41 ,x_creation_date IN DATE
42 ,x_created_by IN NUMBER
43 ,x_normalize IN VARCHAR2
44 ,x_schedule_day IN NUMBER
45 ,x_payment_purpose_code IN VARCHAR2
46 ,x_payment_term_type_code IN VARCHAR2
47 ,x_accrual_account_id IN NUMBER
48 ,x_project_id IN NUMBER
49 ,x_task_id IN NUMBER
50 ,x_organization_id IN NUMBER
51 ,x_expenditure_type IN VARCHAR2
52 ,x_expenditure_item_date IN DATE
53 ,x_vendor_id IN NUMBER
54 ,x_vendor_site_id IN NUMBER
55 ,x_customer_id IN NUMBER
56 ,x_customer_site_use_id IN NUMBER
57 ,x_cust_ship_site_id IN NUMBER
58 ,x_ap_ar_term_id IN NUMBER
59 ,x_cust_trx_type_id IN NUMBER
60 ,x_tax_group_id IN NUMBER
61 ,x_tax_code_id IN NUMBER
62 ,x_tax_classification_code IN VARCHAR2
63 ,x_distribution_set_id IN NUMBER
64 ,x_inv_rule_id IN NUMBER
65 ,x_account_rule_id IN NUMBER
66 ,x_salesrep_id IN NUMBER
67 ,x_tax_included IN VARCHAR2
68 ,x_po_header_id IN NUMBER
69 ,x_cust_po_number IN VARCHAR2
70 ,x_receipt_method_id IN NUMBER
71 ,x_location_id IN NUMBER
72 ,x_active IN VARCHAR2
73 ,x_description IN VARCHAR2
74 ,x_term_template_type IN VARCHAR2
75 ,x_last_update_login IN NUMBER
76 ,x_attribute_category IN VARCHAR2
77 ,x_attribute1 IN VARCHAR2
78 ,x_attribute2 IN VARCHAR2
79 ,x_attribute3 IN VARCHAR2
80 ,x_attribute4 IN VARCHAR2
81 ,x_attribute5 IN VARCHAR2
82 ,x_attribute6 IN VARCHAR2
83 ,x_attribute7 IN VARCHAR2
84 ,x_attribute8 IN VARCHAR2
85 ,x_attribute9 IN VARCHAR2
86 ,x_attribute10 IN VARCHAR2
87 ,x_attribute11 IN VARCHAR2
88 ,x_attribute12 IN VARCHAR2
89 ,x_attribute13 IN VARCHAR2
90 ,x_attribute14 IN VARCHAR2
91 ,x_attribute15 IN VARCHAR2
92 ,x_org_id NUMBER default NULL
93 );
94
95
96 ------------------------------------------------------------------------
97 -- PROCEDURE : UPDATE_ROW
98 ------------------------------------------------------------------------
99 PROCEDURE update_row (
100 x_rowid IN VARCHAR2
101 ,x_term_template_id IN NUMBER
102 ,x_name IN VARCHAR2
103 ,x_set_of_books_id IN NUMBER
104 ,x_currency_code IN VARCHAR2
105 ,x_last_update_date IN DATE
106 ,x_last_updated_by IN NUMBER
107 ,x_normalize IN VARCHAR2
108 ,x_schedule_day IN NUMBER
109 ,x_payment_purpose_code IN VARCHAR2
110 ,x_payment_term_type_code IN VARCHAR2
111 ,x_accrual_account_id IN NUMBER
112 ,x_project_id IN NUMBER
113 ,x_task_id IN NUMBER
114 ,x_organization_id IN NUMBER
115 ,x_expenditure_type IN VARCHAR2
116 ,x_expenditure_item_date IN DATE
117 ,x_vendor_id IN NUMBER
118 ,x_vendor_site_id IN NUMBER
119 ,x_customer_id IN NUMBER
120 ,x_customer_site_use_id IN NUMBER
121 ,x_cust_ship_site_id IN NUMBER
122 ,x_ap_ar_term_id IN NUMBER
123 ,x_cust_trx_type_id IN NUMBER
124 ,x_tax_group_id IN NUMBER
125 ,x_tax_code_id IN NUMBER
126 ,x_tax_classification_code IN VARCHAR2
127 ,x_distribution_set_id IN NUMBER
128 ,x_inv_rule_id IN NUMBER
129 ,x_account_rule_id IN NUMBER
130 ,x_salesrep_id IN NUMBER
131 ,x_tax_included IN VARCHAR2
132 ,x_po_header_id IN NUMBER
133 ,x_cust_po_number IN VARCHAR2
134 ,x_receipt_method_id IN NUMBER
135 ,x_location_id IN NUMBER
136 ,x_active IN VARCHAR2
137 ,x_description IN VARCHAR2
138 ,x_term_template_type IN VARCHAR2
139 ,x_last_update_login IN NUMBER
140 ,x_attribute_category IN VARCHAR2
141 ,x_attribute1 IN VARCHAR2
142 ,x_attribute2 IN VARCHAR2
143 ,x_attribute3 IN VARCHAR2
144 ,x_attribute4 IN VARCHAR2
145 ,x_attribute5 IN VARCHAR2
146 ,x_attribute6 IN VARCHAR2
147 ,x_attribute7 IN VARCHAR2
148 ,x_attribute8 IN VARCHAR2
149 ,x_attribute9 IN VARCHAR2
150 ,x_attribute10 IN VARCHAR2
151 ,x_attribute11 IN VARCHAR2
152 ,x_attribute12 IN VARCHAR2
153 ,x_attribute13 IN VARCHAR2
154 ,x_attribute14 IN VARCHAR2
155 ,x_attribute15 IN VARCHAR2
156 );
157
158
159 ------------------------------------------------------------------------
160 -- PROCEDURE : LOCK_ROW
161 ------------------------------------------------------------------------
162 PROCEDURE lock_row (
163 x_rowid IN VARCHAR2
164 ,x_term_template_id IN NUMBER
165 ,x_name IN VARCHAR2
166 ,x_set_of_books_id IN NUMBER
167 ,x_currency_code IN VARCHAR2
168 ,x_normalize IN VARCHAR2
169 ,x_schedule_day IN NUMBER
170 ,x_payment_purpose_code IN VARCHAR2
171 ,x_payment_term_type_code IN VARCHAR2
172 ,x_accrual_account_id IN NUMBER
173 ,x_project_id IN NUMBER
174 ,x_task_id IN NUMBER
175 ,x_organization_id IN NUMBER
176 ,x_expenditure_type IN VARCHAR2
177 ,x_expenditure_item_date IN DATE
178 ,x_vendor_id IN NUMBER
179 ,x_vendor_site_id IN NUMBER
180 ,x_customer_id IN NUMBER
181 ,x_customer_site_use_id IN NUMBER
182 ,x_cust_ship_site_id IN NUMBER
183 ,x_ap_ar_term_id IN NUMBER
184 ,x_cust_trx_type_id IN NUMBER
185 ,x_tax_group_id IN NUMBER
186 ,x_tax_code_id IN NUMBER
187 ,x_tax_classification_code IN VARCHAR2
188 ,x_distribution_set_id IN NUMBER
189 ,x_inv_rule_id IN NUMBER
190 ,x_account_rule_id IN NUMBER
191 ,x_salesrep_id IN NUMBER
192 ,x_tax_included IN VARCHAR2
193 ,x_po_header_id IN NUMBER
194 ,x_cust_po_number IN VARCHAR2
195 ,x_receipt_method_id IN NUMBER
196 ,x_location_id IN NUMBER
197 ,x_active IN VARCHAR2
198 ,x_description IN VARCHAR2
199 ,x_attribute_category IN VARCHAR2
200 ,x_attribute1 IN VARCHAR2
201 ,x_attribute2 IN VARCHAR2
202 ,x_attribute3 IN VARCHAR2
203 ,x_attribute4 IN VARCHAR2
204 ,x_attribute5 IN VARCHAR2
205 ,x_attribute6 IN VARCHAR2
206 ,x_attribute7 IN VARCHAR2
207 ,x_attribute8 IN VARCHAR2
208 ,x_attribute9 IN VARCHAR2
209 ,x_attribute10 IN VARCHAR2
210 ,x_attribute11 IN VARCHAR2
211 ,x_attribute12 IN VARCHAR2
212 ,x_attribute13 IN VARCHAR2
213 ,x_attribute14 IN VARCHAR2
214 ,x_attribute15 IN VARCHAR2
215 );
216
217
218 ------------------------------------------------------------------------
219 -- PROCEDURE : DELETE_ROW
220 ------------------------------------------------------------------------
221 PROCEDURE delete_row (
222 x_rowid IN VARCHAR2
223 );
224
225 ------------------------------------------------------------------------
226 -- PROCEDURE : DELETE_ROW
227 ------------------------------------------------------------------------
228 PROCEDURE delete_row (
229 x_term_template_id IN NUMBER
230 );
231
232
233 ---------------------------------------------------------------------------
234 -- PROCEDURE : check Unique template name
235 ------------------------------------------------------------------------
236 PROCEDURE check_unq_term_template (
237 x_return_status IN OUT NOCOPY VARCHAR2
238 ,x_term_template_id IN NUMBER
239 ,x_name IN VARCHAR2
240 ,x_org_id IN NUMBER default NULL
241 );
242 END pn_term_templates_pkg;