[Home] [Help]
PACKAGE: APPS.CE_FORECAST_ROWS1_PKG
Source
1 PACKAGE CE_FORECAST_ROWS1_PKG AUTHID CURRENT_USER as
2 /* $Header: cefrow1s.pls 120.1 2002/11/12 21:26:00 bhchung ship $ */
3 --
4 -- Package
5 -- CE_FORECAST_ROWS1_PKG
6 -- Purpose
7 -- To group all the procedures/functions for table handling of the
8 -- ce_forecast_rows table.
9 -- History
10 -- 07.10.96 C. Kawamoto Created
11 --
12 G_spec_revision VARCHAR2(1000) := '$Revision: 120.1 $';
13
14 FUNCTION spec_revision RETURN VARCHAR2;
15
16 FUNCTION body_revision RETURN VARCHAR2;
17
18 --
19 -- Procedure
20 -- Check_Unique
21 -- Purpose
22 -- Checks the uniqueness of the forecast row inserted.
23 -- History
24 -- 07.10.96 C. Kawamoto Created
25 -- Example
26 -- CE_FORECAST_ROWS1_PKG.Check_Unique(...);
27 -- Notes
28 --
29 PROCEDURE Check_Unique(
30 X_rowid VARCHAR2,
31 X_forecast_header_id NUMBER,
32 X_row_number NUMBER);
33
34 --
35 -- Procedure
36 -- insert_row
37 -- Purpose
38 -- To insert new row to ce_forecast_rows.
39 -- History
40 -- 07.10.96 C. Kawamoto Created
41 -- Example
42 -- CE_FORECAST_ROWS1_PKG.Insert_Row(...)
43 -- Notes
44 --
45
46 PROCEDURE Insert_Row(
47 X_rowid IN OUT NOCOPY VARCHAR2,
48 X_forecast_row_id IN OUT NOCOPY NUMBER,
49 X_forecast_header_id NUMBER,
50 X_row_number NUMBER,
51 X_trx_type VARCHAR2,
52 X_lead_time NUMBER,
53 X_forecast_method VARCHAR2,
54 X_discount_option VARCHAR2,
55 X_order_status VARCHAR2,
56 X_order_date_type VARCHAR2,
57 X_code_combination_id NUMBER,
58 X_set_of_books_id NUMBER,
59 X_org_id NUMBER,
60 X_chart_of_accounts_id NUMBER,
61 X_budget_name VARCHAR2,
62 X_budget_version_id NUMBER,
63 X_encumbrance_type_id NUMBER,
64 X_roll_forward_type VARCHAR2,
65 X_roll_forward_period NUMBER,
66 X_customer_profile_class_id NUMBER,
67 X_include_dispute_flag VARCHAR2,
68 X_sales_stage_id NUMBER,
69 X_channel_code VARCHAR2,
70 X_win_probability NUMBER,
71 X_sales_forecast_status VARCHAR2,
72 X_receipt_method_id NUMBER,
73 X_bank_account_id NUMBER,
74 X_payment_method VARCHAR2,
75 X_pay_group VARCHAR2,
76 X_payment_priority NUMBER,
77 X_vendor_type VARCHAR2,
78 X_authorization_status VARCHAR2,
79 X_type VARCHAR2,
80 X_budget_type VARCHAR2,
81 X_budget_version VARCHAR2,
82 X_include_hold_flag VARCHAR2,
83 X_include_net_cash_flag VARCHAR2,
84 X_created_by NUMBER,
85 X_creation_date DATE,
86 X_last_updated_by NUMBER,
87 X_last_update_date DATE,
88 X_last_update_login NUMBER,
89 X_org_payment_method_id NUMBER,
90 X_xtr_bank_account VARCHAR2,
91 X_exclude_indic_exp VARCHAR2,
92 X_company_code VARCHAR2,
93 X_attribute_category VARCHAR2,
94 X_attribute1 VARCHAR2,
95 X_attribute2 VARCHAR2,
96 X_attribute3 VARCHAR2,
97 X_attribute4 VARCHAR2,
98 X_attribute5 VARCHAR2,
99 X_attribute6 VARCHAR2,
100 X_attribute7 VARCHAR2,
101 X_attribute8 VARCHAR2,
102 X_attribute9 VARCHAR2,
103 X_attribute10 VARCHAR2,
104 X_attribute11 VARCHAR2,
105 X_attribute12 VARCHAR2,
106 X_attribute13 VARCHAR2,
107 X_attribute14 VARCHAR2,
108 X_attribute15 VARCHAR2,
109 X_description VARCHAR2,
110 X_payroll_id NUMBER,
111 X_external_source_type VARCHAR2,
112 X_criteria_category VARCHAR2,
113 X_criteria1 VARCHAR2,
114 X_criteria2 VARCHAR2,
115 X_criteria3 VARCHAR2,
116 X_criteria4 VARCHAR2,
117 X_criteria5 VARCHAR2,
118 X_criteria6 VARCHAR2,
119 X_criteria7 VARCHAR2,
120 X_criteria8 VARCHAR2,
121 X_criteria9 VARCHAR2,
122 X_criteria10 VARCHAR2,
123 X_criteria11 VARCHAR2,
124 X_criteria12 VARCHAR2,
125 X_criteria13 VARCHAR2,
126 X_criteria14 VARCHAR2,
127 X_criteria15 VARCHAR2,
128 X_use_average_payment_days VARCHAR2 DEFAULT NULL,
129 X_period NUMBER DEFAULT NULL,
130 X_order_type_id NUMBER DEFAULT NULL,
131 X_use_payment_terms VARCHAR2 DEFAULT NULL);
132
133 --
134 -- Procedure
135 -- lock_row
136 -- Purpose
137 -- To lock a row from ce_forecast_rows.
138 -- History
139 -- 07.10.96 C. Kawamoto Created
140 -- Example
141 -- CE_FORECAST_ROWS1_PKG.Lock_Row(...)
142 -- Notes
143 --
144
145
146 PROCEDURE Lock_Row(
147 X_rowid VARCHAR2,
148 X_forecast_row_id NUMBER,
149 X_forecast_header_id NUMBER,
150 X_row_number NUMBER,
151 X_trx_type VARCHAR2,
152 X_lead_time NUMBER,
153 X_forecast_method VARCHAR2,
154 X_discount_option VARCHAR2,
155 X_order_status VARCHAR2,
156 X_order_date_type VARCHAR2,
157 X_code_combination_id NUMBER,
158 X_set_of_books_id NUMBER,
159 X_org_id NUMBER,
160 X_chart_of_accounts_id NUMBER,
161 X_budget_name VARCHAR2,
162 X_budget_version_id NUMBER,
163 X_encumbrance_type_id NUMBER,
164 X_roll_forward_type VARCHAR2,
165 X_roll_forward_period NUMBER,
166 X_customer_profile_class_id NUMBER,
167 X_include_dispute_flag VARCHAR2,
168 X_sales_stage_id NUMBER,
169 X_channel_code VARCHAR2,
170 X_win_probability NUMBER,
171 X_sales_forecast_status VARCHAR2,
172 X_receipt_method_id NUMBER,
173 X_bank_account_id NUMBER,
174 X_payment_method VARCHAR2,
175 X_pay_group VARCHAR2,
176 X_payment_priority NUMBER,
177 X_vendor_type VARCHAR2,
178 X_authorization_status VARCHAR2,
179 X_type VARCHAR2,
180 X_budget_type VARCHAR2,
181 X_budget_version VARCHAR2,
182 X_include_hold_flag VARCHAR2,
183 X_include_net_cash_flag VARCHAR2,
184 X_created_by NUMBER,
185 X_creation_date DATE,
186 X_last_updated_by NUMBER,
187 X_last_update_date DATE,
188 X_last_update_login NUMBER,
189 X_org_payment_method_id NUMBER,
190 X_xtr_bank_account VARCHAR2,
191 X_exclude_indic_exp VARCHAR2,
192 X_company_code VARCHAR2,
193 X_attribute_category VARCHAR2,
194 X_attribute1 VARCHAR2,
195 X_attribute2 VARCHAR2,
196 X_attribute3 VARCHAR2,
197 X_attribute4 VARCHAR2,
198 X_attribute5 VARCHAR2,
199 X_attribute6 VARCHAR2,
200 X_attribute7 VARCHAR2,
201 X_attribute8 VARCHAR2,
202 X_attribute9 VARCHAR2,
203 X_attribute10 VARCHAR2,
204 X_attribute11 VARCHAR2,
205 X_attribute12 VARCHAR2,
206 X_attribute13 VARCHAR2,
207 X_attribute14 VARCHAR2,
208 X_attribute15 VARCHAR2,
209 X_description VARCHAR2,
210 X_payroll_id NUMBER,
211 X_external_source_type VARCHAR2,
212 X_criteria_category VARCHAR2,
213 X_criteria1 VARCHAR2,
214 X_criteria2 VARCHAR2,
215 X_criteria3 VARCHAR2,
216 X_criteria4 VARCHAR2,
217 X_criteria5 VARCHAR2,
218 X_criteria6 VARCHAR2,
219 X_criteria7 VARCHAR2,
220 X_criteria8 VARCHAR2,
221 X_criteria9 VARCHAR2,
222 X_criteria10 VARCHAR2,
223 X_criteria11 VARCHAR2,
224 X_criteria12 VARCHAR2,
225 X_criteria13 VARCHAR2,
226 X_criteria14 VARCHAR2,
227 X_criteria15 VARCHAR2,
228 X_use_average_payment_days VARCHAR2 DEFAULT NULL,
229 X_period NUMBER DEFAULT NULL,
230 X_order_type_id NUMBER DEFAULT NULL,
231 X_use_payment_terms VARCHAR2 DEFAULT NULL);
232
233
234 END CE_FORECAST_ROWS1_PKG;