[Home] [Help]
PACKAGE: APPS.CE_FORECAST_ROWS2_PKG
Source
1 PACKAGE CE_FORECAST_ROWS2_PKG AUTHID CURRENT_USER as
2 /* $Header: cefrow2s.pls 120.0 2002/08/24 02:36:18 appldev noship $ */
3 --
4 -- Package
5 -- CE_FORECAST_ROWS2_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.0 $';
13
14 FUNCTION spec_revision RETURN VARCHAR2;
15
16 FUNCTION body_revision RETURN VARCHAR2;
17
18 --
19 -- Procedure
20 -- Update_Row
21 -- Purpose
22 -- To update ce_forecast_rows with changes made.
23 -- History
24 -- 07.10.96 C. Kawamoto Created
25 -- Example
26 -- CE_FORECAST_ROWS2_PKG.Update_Row(...);
27 -- Notes
28 --
29
30
31 PROCEDURE Update_Row(
32 X_rowid VARCHAR2,
33 X_forecast_row_id NUMBER,
34 X_forecast_header_id NUMBER,
35 X_row_number NUMBER,
36 X_trx_type VARCHAR2,
37 X_lead_time NUMBER,
38 X_forecast_method VARCHAR2,
39 X_discount_option VARCHAR2,
40 X_order_status VARCHAR2,
41 X_order_date_type VARCHAR2,
42 X_code_combination_id NUMBER,
43 X_set_of_books_id NUMBER,
44 X_org_id NUMBER,
45 X_chart_of_accounts_id NUMBER,
46 X_budget_name VARCHAR2,
47 X_budget_version_id NUMBER,
48 X_encumbrance_type_id NUMBER,
49 X_roll_forward_type VARCHAR2,
50 X_roll_forward_period NUMBER,
51 X_customer_profile_class_id NUMBER,
52 X_include_dispute_flag VARCHAR2,
53 X_sales_stage_id NUMBER,
54 X_channel_code VARCHAR2,
55 X_win_probability NUMBER,
56 X_sales_forecast_status VARCHAR2,
57 X_receipt_method_id NUMBER,
58 X_bank_account_id NUMBER,
59 X_payment_method VARCHAR2,
60 X_pay_group VARCHAR2,
61 X_payment_priority NUMBER,
62 X_vendor_type VARCHAR2,
63 X_authorization_status VARCHAR2,
64 X_type VARCHAR2,
65 X_budget_type VARCHAR2,
66 X_budget_version VARCHAR2,
67 X_include_hold_flag VARCHAR2,
68 X_include_net_cash_flag VARCHAR2,
69 X_created_by NUMBER,
70 X_creation_date DATE,
71 X_last_updated_by NUMBER,
72 X_last_update_date DATE,
73 X_last_update_login NUMBER,
74 X_org_payment_method_id NUMBER,
75 X_xtr_bank_account VARCHAR2,
76 X_exclude_indic_exp VARCHAR2,
77 X_company_code VARCHAR2,
78 X_attribute_category VARCHAR2,
79 X_attribute1 VARCHAR2,
80 X_attribute2 VARCHAR2,
81 X_attribute3 VARCHAR2,
82 X_attribute4 VARCHAR2,
83 X_attribute5 VARCHAR2,
84 X_attribute6 VARCHAR2,
85 X_attribute7 VARCHAR2,
86 X_attribute8 VARCHAR2,
87 X_attribute9 VARCHAR2,
88 X_attribute10 VARCHAR2,
89 X_attribute11 VARCHAR2,
90 X_attribute12 VARCHAR2,
91 X_attribute13 VARCHAR2,
92 X_attribute14 VARCHAR2,
93 X_attribute15 VARCHAR2,
94 X_description VARCHAR2,
95 X_payroll_id NUMBER,
96 X_external_source_type VARCHAR2,
97 X_criteria_category VARCHAR2,
98 X_criteria1 VARCHAR2,
99 X_criteria2 VARCHAR2,
100 X_criteria3 VARCHAR2,
101 X_criteria4 VARCHAR2,
102 X_criteria5 VARCHAR2,
103 X_criteria6 VARCHAR2,
104 X_criteria7 VARCHAR2,
105 X_criteria8 VARCHAR2,
106 X_criteria9 VARCHAR2,
107 X_criteria10 VARCHAR2,
108 X_criteria11 VARCHAR2,
109 X_criteria12 VARCHAR2,
110 X_criteria13 VARCHAR2,
111 X_criteria14 VARCHAR2,
112 X_criteria15 VARCHAR2,
113 X_use_average_payment_days VARCHAR2 DEFAULT NULL,
114 X_period NUMBER DEFAULT NULL,
115 X_order_type_id NUMBER DEFAULT NULL,
116 X_use_payment_terms VARCHAR2 DEFAULT NULL);
117
118 --
119 -- Procedure
120 -- Delete_Row
121 -- Purpose
122 -- To delete a row from ce_forecast_rows.
123 -- History
124 -- 07.10.96 C. Kawamoto Created
125 -- Example
126 -- CE_FORECAST_ROWS2_PKG.Delete_Row(...);
127 -- Notes
128 --
129
130 PROCEDURE Delete_Row(X_rowid VARCHAR2);
131
132 --
133 -- Procedure
134 -- Delete_Forecast_Cells
135 -- Purpose
136 -- To delete all forecast cells belonging the forecast template Row
137 -- History
138 -- 07.10.96 C. Kawamoto Created
139 -- Example
140 -- CE_FORECAST_ROWS_PKG.Delete_Forecast_Cells(...)
141 -- Notes
142 --
143 PROCEDURE Delete_Forecast_Cells(X_rowid VARCHAR2);
144
145
146 END CE_FORECAST_ROWS2_PKG;