1 PACKAGE OE_SHP_PROCESS AUTHID CURRENT_USER AS
2 /* $Header: OEXSHPRS.pls 115.1 99/07/16 08:15:57 porting shi $ */
3
4 PROCEDURE Apply_Ordered_Quantity_Change
5 (
6 P_Lines_Item_Type_Code IN VARCHAR2,
7 P_Lines_Ser_Flag IN VARCHAR2,
8 P_Ord_Enforce_List_Prices_Flag IN VARCHAR2,
9 P_Shp_Config_Flag OUT VARCHAR2,
10 P_Shp_Sch_Flag OUT VARCHAR2,
11 P_Shp_Adj_Flag OUT VARCHAR2,
12 P_Shp_Apply_Ord_Adj_Flag OUT VARCHAR2,
13 P_Shp_Credit_Flag OUT VARCHAR2,
14 P_Shp_Ser_Flag IN OUT VARCHAR2,
15 P_Shp_Schedule_Quantity_Tot IN OUT NUMBER,
16 P_Line_Details_S_Qty_Total OUT NUMBER,
17 P_Shp_Installation_Quantity OUT NUMBER,
18 P_Shp_Ordered_Quantity IN NUMBER,
19 P_Shp_Open_Quantity IN OUT NUMBER,
20 P_Shp_Cancelled_Quantity IN NUMBER,
21 P_return_Status IN OUT VARCHAR2
22 );
23
24
25 PROCEDURE Get_Shipment_Detail_Controls
26 (
27 P_Lines_Item_Type_Code IN VARCHAR2,
28 P_Lines_Ser_Flag IN VARCHAR2,
29 P_Ord_Enforce_List_Prices_Flag IN VARCHAR2,
30 P_Shp_Config_Flag OUT VARCHAR2,
31 P_Shp_Sch_Flag OUT VARCHAR2,
32 P_Shp_Adj_Flag OUT VARCHAR2,
33 P_Shp_Apply_Ord_Adj_Flag OUT VARCHAR2,
34 P_Shp_Credit_Flag OUT VARCHAR2,
35 P_Shp_Ser_Flag OUT VARCHAR2,
36 P_return_Status OUT VARCHAR2
37 );
38
39 PROCEDURE Query_Shipment_Total
40 (
41 P_Shp_Row_Id IN VARCHAR2,
42 P_Shp_Line_Id IN NUMBER,
43 P_Lines_Line_Id IN NUMBER,
44 P_Shp_Line_Type_Code IN VARCHAR2,
45 P_Shp_serviceable_Flag IN VARCHAR2,
46 P_Order_Currency_Precision IN NUMBER,
47 P_Shp_Selling_Price IN NUMBER,
48 P_Shp_Line_Total IN OUT NUMBER,
49 P_Shp_Total IN OUT NUMBER,
50 P_Shp_Ordered_Quantity IN NUMBER,
51 P_Shp_Open_Quantity IN OUT NUMBER,
52 P_Shp_Cancelled_Quantity IN NUMBER,
53 P_Shp_Service_Total OUT NUMBER,
54 P_Shp_Query_Total OUT VARCHAR2,
55 P_Return_Status IN OUT VARCHAR2
56 );
57
58 PROCEDURE Calc_Shipment_Total
59 (
60 P_Shp_Line_Total OUT NUMBER,
61 P_Shp_Ordered_Quantity IN NUMBER,
62 P_Shp_Open_Quantity IN OUT NUMBER,
63 P_Shp_Cancelled_Quantity IN NUMBER,
64 P_Shp_Selling_Price IN NUMBER,
65 P_Shp_Line_Type_Code IN VARCHAR2,
66 P_Return_Status IN OUT VARCHAR2
67 );
68
69 PROCEDURE Total_Shipment
70 (
71 P_Shp_Total IN OUT NUMBER,
72 P_Shp_Line_Total IN OUT NUMBER,
73 P_Shp_Ordered_Quantity IN NUMBER,
74 P_Shp_Open_Quantity IN OUT NUMBER,
75 P_Shp_Cancelled_Quantity IN NUMBER,
76 P_Shp_Selling_Price IN NUMBER,
77 P_Shp_Line_Type_Code IN VARCHAR2,
78 P_return_Status IN OUT VARCHAR2
79 );
80
81 PROCEDURE Calc_Line_Total
82 (
83 P_Lines_Line_Total OUT NUMBER,
84 P_Lines_Ordered_Quantity IN NUMBER,
85 P_Lines_Open_Quantity IN OUT NUMBER,
86 P_Lines_Cancelled_Quantity IN NUMBER,
87 P_Lines_Selling_Price IN NUMBER,
88 P_Lines_Line_Type_Code IN VARCHAR2,
89 P_Lines_Item_Type_Code IN VARCHAR2,
90 P_Lines_Service_Duration IN NUMBER,
91 P_Return_Status IN OUT VARCHAR2
92 );
93
94 PROCEDURE Total_Line
95 (
96 P_Lines_Total IN OUT NUMBER,
97 P_Lines_Line_Total IN OUT NUMBER,
98 P_Lines_Ordered_Quantity IN NUMBER,
99 P_Lines_Open_Quantity IN OUT NUMBER,
100 P_Lines_Cancelled_Quantity IN NUMBER,
101 P_Lines_Selling_Price IN NUMBER,
102 P_Lines_Line_Type_Code IN VARCHAR2,
103 P_Lines_Item_Type_Code IN VARCHAR2,
104 P_Lines_Service_Duration IN NUMBER,
105 P_return_Status IN OUT VARCHAR2
106 );
107
108 PROCEDURE Shipment_Total
109 (
110 P_Line_Id IN NUMBER,
111 P_Line_Total OUT NUMBER,
112 P_Return_Status OUT VARCHAR2
113 );
114
115
116 PROCEDURE Shipment_Quantity_Total
117 (
118 P_Lines_Line_Id IN NUMBER,
119 P_Lines_Shipment_Qty_Total OUT NUMBER,
120 P_Lines_Shipment_Lines_Count OUT NUMBER,
121 P_return_Status OUT VARCHAR2
122 );
123
124 PROCEDURE Update_Line_Type_Code
125 (
126 P_Line_Id IN NUMBER,
127 P_Line_Type_Code IN VARCHAR2,
128 P_Return_Status OUT VARCHAR2
129 );
130
131 PROCEDURE Match_Shipment_Quantity
132 (
133 P_Ship_Sched_Line_Id IN OUT NUMBER,
134 P_Line_RowId IN VARCHAR2,
135 P_Open_Line_Quantity IN OUT NUMBER,
136 P_Total_Shipment_Quantity IN OUT NUMBER,
137 P_Return_Status OUT VARCHAR2
138 );
139
140
141 PROCEDURE Update_Line_Quantity
142 (
143 P_Ship_Sched_Line_Id IN OUT NUMBER,
144 P_Total_Shipment_Quantity IN OUT NUMBER,
145 P_Open_Line_Quantity IN OUT NUMBER,
146 P_Line_Quantity IN OUT NUMBER,
147 P_Return_Status OUT VARCHAR2
148 );
149
150 PROCEDURE Update_Parent_Option_Quantity
151 (
152 P_Line_Id IN NUMBER,
153 P_Total_Shipment_Quantity IN NUMBER,
154 P_Ordered_Quantity IN NUMBER,
155 P_Cancelled_Quantity IN NUMBER,
156 P_Return_Status OUT VARCHAR2
157 );
158
159 END OE_SHP_PROCESS;