[Home] [Help]
PACKAGE: APPS.MRP_EXPL_STD_MANDATORY
Source
1 PACKAGE MRP_EXPL_STD_MANDATORY AUTHID CURRENT_USER AS
2 /* $Header: MRPDSODS.pls 115.10 2003/06/19 18:22:21 pshah noship $ */
3
4 G_MRP_DEBUG VARCHAR2(1) := FND_PROFILE.Value('MRP_DEBUG');
5
6 TYPE number_arr IS TABLE OF number;
7 TYPE char3_arr IS TABLE OF varchar2(3);
8 TYPE char30_arr IS TABLE OF varchar2(30);
9 TYPE date_arr IS TABLE OF date;
10
11 TYPE GET_OE_Rec_Typ is RECORD (
12 Inventory_Item_Id number_arr := number_arr(),
13 Source_Organization_Id number_arr := number_arr(),
14 Organization_Id number_arr := number_arr(),
15 Identifier number_arr := number_arr(),
16 Demand_Source_Header_Id number_arr := number_arr(),
17 Quantity_Ordered number_arr := number_arr(),
18 Quantity_UOM char3_arr := char3_arr(),
19 Requested_Ship_Date date_arr := date_arr(),
20 Demand_Class char30_arr := char30_arr(),
21 mfg_lead_time number_arr := number_arr(),
22 ITEM_TYPE_CODE char30_arr := char30_arr()
23 );
24
25 FUNCTION Explode_ATO_SM_COMPS(p_lrn IN NUMBER) RETURN INTEGER;
26
27 PROCEDURE LOG_ERROR( pBUFF IN VARCHAR2);
28
29 END MRP_EXPL_STD_MANDATORY;