[Home] [Help]
PACKAGE: APPS.AS_FOUNDATION_PUB
Source
1 PACKAGE AS_FOUNDATION_PUB as
2 /* $Header: asxpfous.pls 120.1 2005/06/05 22:52:20 appldev $ */
3
4 -- Start of Comments
5 --
6 -- NAME
7 -- AS_FOUNDATION_PUB
8 --
9 -- PURPOSE
10 -- This package is a public utility API for OSM
11 --
12 -- Procedures:
13 --
14 --
15 -- NOTES
16 --
17 --
18 -- HISTORY
19 -- 8/6/98 Alhung Created
20 -- Sept 1, 98 cklee Added new function Get_Constant
21 -- 06/22/99 awu Added get_messages, get_periodNames
22 -- 06/29/2000 Srikanth Deleted get_messages as it is implemented in
23 -- as_utility_pub
24 -- End of Comments
25
26 -- Following are lookup tables that caller can use for.
27
28 G_AS_LOOKUPS VARCHAR2(30) := 'AS_LOOKUPS';
29 G_AR_LOOKUPS VARCHAR2(30) := 'AR_LOOKUPS';
30 --G_SO_LOOKUPS VARCHAR2(30) := 'SO_LOOKUPS';
31 G_HR_LOOKUPS VARCHAR2(30) := 'HR_LOOKUPS';
32 G_FND_COMMON_LOOKUPS VARCHAR2(30) := 'FND_COMMON_LOOKUPS';
33 G_CS_LOOKUPS VARCHAR2(30) := 'CS_LOOKUPS';
34
35 -- ***********************
36 -- Composite Types
37 -- ***********************
38
39 -- Start of Comments
40 --
41 -- Order by record: inventory_item_type
42 --
43 -- parameters:
44 -- inventory_item_id Inventory item identifier
45 -- organization_id Organization identifier
46 -- enabled_flag Flexfield segment enabled flag
47 -- start_date_active Flexfield segment start date
48 -- end_date_active Flexfield segment end date
49 -- description Item description
50 -- concatenated_segments Concatenated Flexfield Segments
51 -- inventory_item_flag Flag indicating inventory item
52 -- item_catalog_group_id Item Catalog group identifier
53 -- Collateral_flag Flag indicattng collateral item
54 -- Primary_UOM_Code primary unit of measure code (Manufacturing)
55 -- Primary_Unit_of_Measure primary stocking unit of measure (Purchasing)
56 -- inventory_item_status_code material status code
57 -- product_family_item_id product familty identifier
58 -- bom_item_type Type of item
59 --
60 -- required: None
61 --
62 -- defaults: None
63 --
64 --
65 -- End of Comments
66
67
68 TYPE inventory_item_rec_type IS RECORD
69 (
70 inventory_item_id Number := NULL,
71 organization_id Number := NULL,
72 enabled_flag Varchar2(1) := NULL,
73 start_date_active date := NULL,
74 end_date_active date := NULL,
75 description Varchar2(240) := NULL,
76 concatenated_segments Varchar2(40) := NULL,
77 inventory_item_flag Varchar2(1) := NULL,
78 item_catalog_group_id Number := NULL,
79 Collateral_flag Varchar2(1) := NULL,
80 Primary_UOM_Code Varchar2(3) := NULL,
81 Primary_Unit_of_Measure Varchar2(25) := NULL,
82 inventory_item_status_code Varchar2(10) := NULL,
83 product_family_item_id Number := NULL,
84 bom_item_type Number := NULL
85
86 );
87
88 TYPE Inventory_Item_tbl_type IS TABLE OF Inventory_Item_rec_type
89 INDEX BY BINARY_INTEGER;
90
91 G_MISS_Inventory_Item_REC inventory_item_rec_type;
92
93
94 -- Start of Comments
95 --
96 -- period name record: util_period_rec_type
97 --
98 -- parameters:
99 --
100 -- required:
101 --
102 -- defaults:
103 -- None
104 -- End of Comments
105
106
107 TYPE util_period_rec_type is RECORD
108 (
109 period_name VARCHAR2(20) := NULL,
110 start_date DATE := NULL,
111 end_date DATE := NULL
112 );
113
114 G_MISS_UTIL_PERIOD_REC util_period_rec_type;
115
116
117 -- Start of Comments
118 --
119 -- Util_Period Table: util_period_tbl_type
120 --
121 -- End of Comments
122
123 TYPE util_period_tbl_type IS TABLE OF util_period_rec_type
124 INDEX BY BINARY_INTEGER;
125
126 G_MISS_UTIL_PERIOD_TBL util_period_tbl_type;
127
128
129
130
131 --
132 -- API name : Get_Inventory_Items
133 -- Type : Private
134 -- Function : Get/Find invenotory items that satisfy caller specified criteria.
135 --
136 -- Pre-reqs : None
137 -- Paramaeters :
138 -- IN :
139 -- p_api_version_number IN NUMBER Required
140 -- p_identity_salesforce_id IN NUMBER Optional
141 -- Default = NULL
142 -- p_init_msg_list IN VARCHAR2 Optional
143 -- Default = FND_API.G_FALSE
144 -- p_inventory_item_rec IN Inventory_Item_Rec Required
145 --
146 -- OUT NOCOPY /* file.sql.39 change */ :
147 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
148 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
149 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
150 -- x_opp_tbl OUT NOCOPY /* file.sql.39 change */ AS_OPPORTUNITY_PUB.Opp_tbl_Type
151 -- x_returned_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
152 -- x_next_rec_ptr OUT NOCOPY /* file.sql.39 change */ NUMBER
153 -- x_tot_rec_count OUT NOCOPY /* file.sql.39 change */ NUMBER
154 --
155 -- Version : Current version 2.0
156 -- Initial version 1.0
157 --
158 -- Requirement:
159 -- 1. p_inventory_item_rec.Organization_id is required for any search.
160 -- Use one of the global variables to set this criteria. Valid values are:
161 -- G_Collateral_Organization, G_Quote_Organization, G_Product_Organization
162 --
163 -- Limitation:
164 -- 1. Only Inventory_item_id, Concatenated_segments, Description,
165 -- Collateral_flag, BOM_item_type are
166 -- considered criteria. Other fields are for viewing purpose only.
167
168 PROCEDURE Get_inventory_items( p_api_version_number IN NUMBER,
169 p_init_msg_list IN VARCHAR2
170 := FND_API.G_FALSE,
171 p_identity_salesforce_id IN NUMBER,
172 p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE,
173 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
174 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
175 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
176 x_inventory_item_tbl OUT NOCOPY /* file.sql.39 change */ AS_FOUNDATION_PUB.inventory_item_TBL_TYPE);
177
178 --
179 -- This function will return constant according to the passed in constant name.
180 -- There is a problem referencing constants from forms. We have to create server-
181 -- side function that return these values.
182 Function Get_Constant(Constant_Name varchar2) return varchar2;
183
184 PROCEDURE Calculate_Amount( p_api_version_number IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
186 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187 p_identity_salesforce_id IN NUMBER,
188 p_inventory_item_rec IN AS_FOUNDATION_PUB.Inventory_Item_REC_TYPE
189 DEFAULT AS_FOUNDATION_PUB.G_MISS_INVENTORY_ITEM_REC,
190 p_secondary_interest_code_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
191 p_currency_code IN VARCHAR2,
192 p_volume IN NUMBER,
193 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
194 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
195 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
196 x_amount OUT NOCOPY /* file.sql.39 change */ NUMBER);
197
198 -- Start of Comments
199 --
200 -- API name : Get_PeriodNames
201 -- Type : Public
202 -- Function : Provide a table of period names, start_date and end date
203 -- by given start_date and end_date or period name.
204 --
205 -- Paramaeters :
206 -- IN :
207 -- p_api_version_number IN NUMBER,
208 -- p_init_msg_list IN VARCHAR2
209 --
210 -- OUT NOCOPY /* file.sql.39 change */ :
211 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2(1)
212 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
213 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
214 --
215 -- Version : Current version 2.0
216 -- Initial version 1.0
217 --
218 --
219 --
220 -- End of Comments
221
222 PROCEDURE Get_PeriodNames
223 ( p_api_version_number IN NUMBER,
224 p_init_msg_list IN VARCHAR2
225 := FND_API.G_FALSE,
226 p_period_rec IN UTIL_PERIOD_REC_TYPE,
227 x_period_tbl OUT NOCOPY /* file.sql.39 change */ UTIL_PERIOD_TBL_TYPE,
228 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
229 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
230 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
231 );
232
233 END AS_FOUNDATION_PUB;