[Home] [Help]
PACKAGE: APPS.MTL_STAT_TYPE_USAGES_PKG
Source
1 PACKAGE MTL_STAT_TYPE_USAGES_PKG AS
2 -- $Header: INVGSTUS.pls 120.2.12000000.2 2007/04/17 06:23:48 nesoni ship $
3 --+=======================================================================+
4 --| Copyright (c) 1999, 2000 Oracle Corporation |
5 --| Redwood Shores, CA, USA |
6 --| All rights reserved. |
7 --+=======================================================================+
8 --| FILENAME |
9 --| INVGSTUS.pls |
10 --| |
11 --| DESCRIPTION |
12 --| Specification of package MTL_STAT_TYPE_USAGES_PKG, table |
13 --| handler for table MTL_STAT_TYPE_USAGES |
14 --| |
15 --| HISTORY |
16 --| 01/27/1999 Herman Poon Created |
17 --| 05/31/1999 Paolo Juvara Modified to reflect changes in |
18 --| MTL_STAT_TYPE_USAGES |
19 --| 06/15/2000 Paolo Juvara Added support for period_type |
20 --| 07/11/2000 Komal Saini Added 2 new columns for Rules Validation |
21 --| 09/19/2001 Yanping Wang Added support for triangulation_mode |
22 --| 01/11/2002 Yanping Wang Added support for reference period rule |
23 --| 3 new columns: reference_period_rule, |
24 --| pending_invoice_days,prior_invoice_days |
25 --| 11/26/02 Vivian Ma Added NOCOPY to IN OUT parameters to |
26 --| comply with new PL/SQL standard for |
27 --| better performance |
28 --| 09/16/2003 Yanping Wang Added support for returns_processing |
29 --| 03/08/2005 Yanping Wang Added support for kit |
30 --| 16/04/2007 Neelam Soni Bug 5920143. Added support for Include |
31 --| Establishments. |
32 --+=======================================================================+
33
34
35 --========================================================================
36 -- PROCEDURE : Insert_Row PUBLIC
37 -- PARAMETERS:
38 --
39 --
40 -- COMMENT : Bug:5920143. New column added include_establishments.
41 --
42 -- EXCEPTIONS:
43 --========================================================================
44 PROCEDURE Insert_Row
45 ( p_rowid IN OUT NOCOPY VARCHAR2
46 , p_legal_entity_id NUMBER
47 , p_zone_code VARCHAR2
48 , p_usage_type VARCHAR2
49 , p_stat_type VARCHAR2
50 , p_period_set_name VARCHAR2
51 , p_period_type VARCHAR2
52 , p_start_period_name VARCHAR2
53 , p_end_period_name VARCHAR2
54 , p_weight_uom_code VARCHAR2
55 , p_entity_branch_reference VARCHAR2
56 , p_conversion_type VARCHAR2
57 , p_conversion_option VARCHAR2
58 , p_category_set_id NUMBER
59 , p_tax_office_code VARCHAR2
60 , p_tax_office_name VARCHAR2
61 , p_tax_office_location_id NUMBER
62 , p_attribute_rule_set_code VARCHAR2
63 , p_alt_uom_rule_set_code VARCHAR2
64 , p_triangulation_mode VARCHAR2
65 , p_reference_period_rule VARCHAR2
66 , p_pending_invoice_days NUMBER
67 , p_prior_invoice_days NUMBER
68 , p_returns_processing VARCHAR2
69 , p_kit_method VARCHAR2
70 , p_weight_precision NUMBER
71 , p_reporting_rounding VARCHAR2
72 , p_include_establishments VARCHAR2
73 , p_last_update_date DATE
74 , p_last_updated_by NUMBER
75 , p_last_update_login NUMBER
76 , p_created_by NUMBER
77 , p_creation_date DATE
78 );
79
80
81 --========================================================================
82 -- PROCEDURE : Lock_Row PUBLIC
83 -- PARAMETERS:
84 --
85 --
86 -- COMMENT : Bug:5920143. New column added include_establishments.
87 --
88 -- EXCEPTIONS:
89 --========================================================================
90 PROCEDURE Lock_Row
91 ( p_rowid IN OUT NOCOPY VARCHAR2
92 , p_legal_entity_id NUMBER
93 , p_zone_code VARCHAR2
94 , p_usage_type VARCHAR2
95 , p_stat_type VARCHAR2
96 , p_period_set_name VARCHAR2
97 , p_period_type VARCHAR2
98 , p_start_period_name VARCHAR2
99 , p_end_period_name VARCHAR2
100 , p_weight_uom_code VARCHAR2
101 , p_entity_branch_reference VARCHAR2
102 , p_conversion_type VARCHAR2
103 , p_conversion_option VARCHAR2
104 , p_category_set_id NUMBER
105 , p_tax_office_code VARCHAR2
106 , p_tax_office_name VARCHAR2
107 , p_tax_office_location_id NUMBER
108 , p_attribute_rule_set_code VARCHAR2
109 , p_alt_uom_rule_set_code VARCHAR2
110 , p_triangulation_mode VARCHAR2
111 , p_reference_period_rule VARCHAR2
112 , p_pending_invoice_days NUMBER
113 , p_prior_invoice_days NUMBER
114 , p_returns_processing VARCHAR2
115 , p_kit_method VARCHAR2
116 , p_weight_precision NUMBER
117 , p_reporting_rounding VARCHAR2
118 , p_include_establishments VARCHAR2
119 );
120
121
122 --========================================================================
123 -- PROCEDURE : Update_Row PUBLIC
124 -- PARAMETERS:
125 --
126 --
127 -- COMMENT : Bug:5920143. New column added include_establishments.
128 --
129 -- EXCEPTIONS:
130 --========================================================================
131 PROCEDURE Update_Row
132 ( p_rowid IN OUT NOCOPY VARCHAR2
133 , p_legal_entity_id NUMBER
134 , p_zone_code VARCHAR2
135 , p_usage_type VARCHAR2
136 , p_stat_type VARCHAR2
137 , p_period_set_name VARCHAR2
138 , p_period_type VARCHAR2
139 , p_start_period_name VARCHAR2
140 , p_end_period_name VARCHAR2
141 , p_weight_uom_code VARCHAR2
142 , p_entity_branch_reference VARCHAR2
143 , p_conversion_type VARCHAR2
144 , p_conversion_option VARCHAR2
145 , p_category_set_id NUMBER
146 , p_tax_office_code VARCHAR2
147 , p_tax_office_name VARCHAR2
148 , p_tax_office_location_id NUMBER
149 , p_attribute_rule_set_code VARCHAR2
150 , p_alt_uom_rule_set_code VARCHAR2
151 , p_triangulation_mode VARCHAR2
152 , p_reference_period_rule VARCHAR2
153 , p_pending_invoice_days NUMBER
154 , p_prior_invoice_days NUMBER
155 , p_returns_processing VARCHAR2
156 , p_kit_method VARCHAR2
157 , p_weight_precision NUMBER
158 , p_reporting_rounding VARCHAR2
159 , p_include_establishments VARCHAR2
160 , p_last_update_date DATE
161 , p_last_updated_by NUMBER
162 , p_last_update_login NUMBER
163 , p_created_by NUMBER
164 , p_creation_date DATE
165 );
166
167
168 --========================================================================
169 -- PROCEDURE : Delete_Row PUBLIC
170 -- PARAMETERS:
171 --
172 --
173 -- COMMENT :
174 --
175 -- EXCEPTIONS:
176 --========================================================================
177 PROCEDURE Delete_Row
178 ( p_rowid IN OUT NOCOPY VARCHAR2
179 );
180
181
182 END MTL_STAT_TYPE_USAGES_PKG;