1 PACKAGE OE_OPT_PROCESS AUTHID CURRENT_USER AS
2 /* $Header: OEXOPPRS.pls 115.1 99/07/16 08:14:01 porting shi $ */
3
4 PROCEDURE Get_Item_Information
5 (
6 Options_Inventory_Item_Id IN NUMBER,
7 Options_Item_Type_Code IN OUT VARCHAR2,
8 Options_Item_Type OUT VARCHAR2,
9 P_Organization_Id IN NUMBER,
10 Lines_Component_Sequence_Id IN NUMBER,
11 Options_Component_Code IN VARCHAR2,
12 Configuration_Parent_Line_Id IN NUMBER,
13 Options_ATO_Flag OUT VARCHAR2,
14 Options_ATO_Line_Id OUT NUMBER,
15 ATO_Parent_Component_Code OUT VARCHAR2,
16 Lines_ATO_Flag IN VARCHAR2 ,
17 Options_Line_Id IN OUT NUMBER,
18 Serviceable_Flag OUT VARCHAR2,
19 Item IN VARCHAR2,
20 Lines_Ship_Model_Comp_Flag IN VARCHAR2,
21 Options_Ship_Model_Comp_Flag OUT VARCHAR2,
22 Options_Plan_Level IN NUMBER,
23 Lines_Creation_Date_Time IN DATE,
24 Return_Status OUT VARCHAR2
25 );
26
27
28 PROCEDURE Get_Option_Detail_Controls
29 (
30 World_Organization_Id IN NUMBER,
31 Options_Inventory_Item_Id IN NUMBER,
32 Options_ATO_Flag IN VARCHAR2,
33 ATO_Parent_Component_Code IN VARCHAR2,
34 Options_Component_Code IN VARCHAR2,
35 Options_ATO_Line_Id IN NUMBER,
36 Options_Schedulable_Flag OUT VARCHAR2,
37 Order_Enforce_List_Prices_Flag IN VARCHAR2,
38 Options_Adjustable_Flag OUT VARCHAR2,
39 Apply_Order_Adjs_Flag OUT VARCHAR2,
40 Options_Serviceable_Flag OUT VARCHAR2,
41 P_return_Status OUT VARCHAR2
42 );
43
44
45 PROCEDURE Get_ATO_Parent_Information
46 (
47 Options_ATO_Line_Id IN NUMBER,
48 Options_ATO_Parent_Comp_Code OUT VARCHAR2,
49 P_Return_Status OUT VARCHAR2
50 );
51
52 PROCEDURE Insert_Installn_Details
53 (
54 P_Line_Id IN NUMBER,
55 P_User_Id IN NUMBER,
56 P_Login_Id IN NUMBER,
57 P_Configuration_Parent_Line_Id IN NUMBER,
58 P_return_Status OUT VARCHAR2
59 );
60
61 PROCEDURE Query_BOM_Quantity
62 (
63 P_Creation_Date_Time IN DATE,
64 P_Component_Sequence_Id IN NUMBER,
65 P_Component_Code IN VARCHAR2,
66 P_Model_Open_Quantity IN NUMBER,
67 P_Component_Quantity IN OUT NUMBER,
68 P_Low_Quantity IN OUT NUMBER,
69 P_High_Quantity IN OUT NUMBER,
70 P_Return_Status OUT VARCHAR2
71 );
72
73 PROCEDURE Set_Update_Subconfig_Flag
74 (
75 P_Row_Id IN VARCHAR2,
76 P_Ordered_Quantity IN NUMBER,
77 P_Update_Subconfig_Flag OUT VARCHAR2,
78 P_Return_Status OUT VARCHAR2
79 );
80
81 END OE_OPT_PROCESS;