DBA Data[Home] [Help]

PACKAGE: APPS.OE_LIN

Source


1 PACKAGE OE_LIN AUTHID CURRENT_USER AS
2 /* $Header: OEXLINSS.pls 115.1 99/07/16 08:13:14 porting shi $ */
3 
4 PROCEDURE Check_Allow_Manual_Discount
5 (
6         P_Price_List_Id                      IN    NUMBER,
7         P_Order_Price_List_Id                IN    NUMBER,
8         P_Order_Order_Type_Id                IN    NUMBER,
9         P_Header_Id                          IN    NUMBER,
10         P_Line_Id                            IN    NUMBER,
11         P_List_Price                         IN    NUMBER,
12         P_Discounting_Privilage              IN    VARCHAR2,
13         P_Global_Result                      OUT   VARCHAR2,
14         P_Check_Multiple_Adj_Flag            IN    VARCHAR2 DEFAULT 'Y'
15 );
16 
17 PROCEDURE Check_Manual_Discount_Priv
18 (
19         X_Price_List_Id                      IN    NUMBER,
20         X_Order_Price_List_Id                IN    NUMBER,
21         X_Order_Order_Type_Id                IN    NUMBER,
22         X_Header_Id                          IN    NUMBER,
23         X_Line_Id                            IN    NUMBER,
24         X_List_Price                         IN    NUMBER,
25         X_Discounting_Privilage              IN    VARCHAR2,
26         X_Global_Result                      OUT   VARCHAR2,
27         X_Reason                             OUT   VARCHAR2,
28         X_Check_Multiple_Adj_Flag            IN    VARCHAR2 DEFAULT 'Y'
29 );
30 
31 
32 PROCEDURE Apply_Manual_Discount
33 (
34         P_Manual_Discount_Id                IN NUMBER,
35         P_List_Price                        IN NUMBER,
36         P_List_Percent                      IN NUMBER,
37         P_Selling_Price                     IN NUMBER,
38         P_Manual_Discount_Percent           IN NUMBER,
39         P_Pricing_Method_Code               IN VARCHAR2,
40         P_Selling_Percent                   OUT NUMBER,
41         P_Header_Id                         IN NUMBER,
42         P_Line_Id                           IN NUMBER,
43         P_User_Id                           IN NUMBER,
44         P_Login_Id                          IN NUMBER,
45         P_Manual_Discount_Line_Id           IN NUMBER,
46         P_Price_List_Id        		    IN NUMBER,
47         P_Order_Price_List_Id               IN NUMBER,
48         P_Order_Order_Type_Id               IN NUMBER,
49         P_Discounting_Privilage             IN VARCHAR2,
50         P_Adjustment_Total          	    OUT NUMBER,
51         P_Global_Result                     OUT VARCHAR2
52 );
53 
54 PROCEDURE Get_Line_Object_Adj_Total
55 (
56         Order_Header_Id               IN    NUMBER,
57         Lin_Obj_Line_Id               IN    NUMBER,
58         Lin_Obj_Apply_Order_Adjs_Flag IN    VARCHAR2,
59         P_Automatic_Flag              IN    VARCHAR2,
60         Lin_Obj_Adjustment_Total      OUT   NUMBER,
61         P_Return_Status               OUT   VARCHAR2
62 );
63 
64 
65 PROCEDURE ATO_Model
66 (
67         ATO_Model_Flag                      IN VARCHAR2,
68         Return_Status                       OUT VARCHAR2
69 );
70 
71 PROCEDURE ATO_Configuration
72 (
73         ATO_Line_Id                         IN NUMBER,
74         Return_Status                       OUT VARCHAR2
75 );
76 
77 PROCEDURE Supply_Reserved
78 (
79         Supply_Reservation_Exists           IN VARCHAR2,
80         Return_Status                       OUT VARCHAR2
81 );
82 
83 PROCEDURE Check_Schedule_Group
84 (
85         DB_Record_Flag                      IN VARCHAR2,
86         Source_Object                       IN VARCHAR2,
87         Return_Status                       OUT VARCHAR2
88 );
89 
90 PROCEDURE Internal_Order
91 (
92         Order_Category                      IN VARCHAR2,
93         Return_Status                       OUT VARCHAR2
94 );
95 
96 PROCEDURE Fully_Released
97 (
98         Row_Id                            IN VARCHAR2,
99         Return_Status                     OUT VARCHAR2
100 );
101 
102 PROCEDURE Fully_Cancelled
103 (
104         Row_Id                            IN VARCHAR2,
105         Return_Status                     OUT VARCHAR2
106 );
107 
108 PROCEDURE Calc_Lin_Obj_Open_Quantity
109 (
110         Lin_Obj_Ordered_Quantity        IN  NUMBER,
111         Lin_Obj_Open_Quantity           OUT NUMBER,
112         Lin_Obj_Cancelled_Quantity      IN  NUMBER,
113         P_return_Status                 OUT VARCHAR2
114 
115 );
116 
117 PROCEDURE Load_ATO_Flag
118 (
119         P_Lin_Obj_Line_Id                   IN  NUMBER,
120         P_Lin_Obj_Item_Type_Code            IN  VARCHAR2,
121         P_Lin_Obj_ATO_Line_Id               IN  NUMBER,
122         P_Lin_Obj_ATO_Flag                  IN  VARCHAR2,
123         P_Lin_Obj_ATO_Model_Flag            IN OUT  VARCHAR2,
124         P_Lin_Obj_Supply_Reserv_Exists     OUT VARCHAR2,
125         P_Lin_Obj_Config_Item_Exists        OUT VARCHAR2,
126         P_Return_Status                     OUT VARCHAR2
127 );
128 
129 PROCEDURE Check_Navigate_Shipments
130 (
131         P_Header_Id                         IN  NUMBER,
132         P_Line_Id                           IN  NUMBER,
133         P_Order_S1                          IN  NUMBER,
134         P_Config_Item_Exists                IN  VARCHAR2,
135         P_Return_Status                     OUT VARCHAR2,
136         P_ITEM_TYPE_CODE                    IN VARCHAR2 default null,
137         P_SERVICE_INSTALLED                 IN VARCHAR2 default 'N'
138 );
139 
140 PROCEDURE Update_Shippable_Flag
141 (
142         P_ATO_Option_Parent_Line            IN  NUMBER,
143         P_Return_Status                     OUT VARCHAR2
144 );
145 
146 END OE_LIN;