1 PACKAGE OE_CANCEL AUTHID CURRENT_USER AS
2 /* $Header: OECANCLS.pls 115.1 99/07/16 08:10:34 porting shi $ */
3
4 procedure CHECK_ORDER_CANCELLABLE(
5 V_HEADER_ID IN NUMBER
6 , V_ORDER_CATEGORY IN VARCHAR2
7 , V_PRINT_ERR_MSG IN NUMBER
8 , V_RESULT OUT NUMBER
9 );
10
11 procedure UPDATE_HEADER_INFO(
12 V_HEADER_ID IN NUMBER
13 , V_ORDER_CATEGORY IN VARCHAR2
14 , V_CANCEL_COMMENT IN LONG
15 , V_CANCEL_CODE IN VARCHAR2
16 , V_LAST_UPDATED_BY IN NUMBER
17 , V_LAST_UPDATE_LOGIN IN NUMBER
18 , V_SOURCE_CODE IN VARCHAR2
19 , V_PRINT_ERR_MSG IN NUMBER
20 , V_RESULT OUT NUMBER);
21
22
23 procedure CHECK_SERVICE(
24 V_LINE_ID IN NUMBER
25 , V_REAL_PARENT_LINE_ID IN NUMBER
26 , V_COMPONENT_CODE IN VARCHAR2
27 , V_ITEM_TYPE_CODE IN VARCHAR2
28 , V_SUBTREE_EXISTS IN NUMBER
29 , V_PRINT_ERR_MSG IN NUMBER
30 , V_RESULT OUT NUMBER
31 );
32
33 procedure CHECK_IF_CONFIG(
34 V_LOOP_LINE_ID IN NUMBER
35 , V_RESULT OUT NUMBER
36 );
37
38
39 procedure CALCULATE_RMA_QTY(
40 V_LINE_ID IN NUMBER
41 , V_S29 IN NUMBER
42 , V_ORDER_QTY IN NUMBER
43 , V_CANCELLED_QTY IN NUMBER
44 , V_RECEIVED_QTY OUT NUMBER
45 , V_ALLOWABLE_CANCEL_QTY OUT NUMBER
46 , V_PRINT_ERR_MSG IN NUMBER
47 , V_RESULT OUT NUMBER
48 );
49
50
51 procedure SET_SERVICE_QTY(
52 V_LINE_ID IN NUMBER
53 , V_ALLOWABLE_CANCEL_QTY OUT NUMBER
54 , V_RESULT OUT NUMBER
55 );
56
57
58
59 procedure NONCONFIG_QTY(
60 V_LOOP_LINE_ID IN NUMBER
61 , V_LOOP_RATIO_DEN IN NUMBER
62 , V_LOOP_RATIO_NUM IN NUMBER
63 , V_S2 IN NUMBER
64 , V_NONCONFIG_QTY OUT NUMBER
65 , V_RESULT OUT NUMBER
66 );
67
68 procedure INCLUDE_QTY(
69 V_LOOP_LINE_ID IN NUMBER
70 , V_TOTAL_QTY_FINAL IN NUMBER
71 , V_LOOP_RATIO_DEN IN NUMBER
72 , V_LOOP_RATIO_NUM IN NUMBER
73 , V_S2 IN NUMBER
74 , V_INCLUDE_QTY OUT NUMBER
75 , V_RESULT OUT NUMBER
76 );
77
78
79 procedure CONFIG_QTY(
80 V_ATO_LOOP_LINE_ID IN NUMBER
81 , V_LOOP_LINE_ID IN NUMBER
82 , V_LOOP_RATIO_DEN IN NUMBER
83 , V_LOOP_RATIO_NUM IN NUMBER
84 , V_S2 IN NUMBER
85 , V_CONFIG_QTY OUT NUMBER
86 , V_RESULT OUT NUMBER
87 );
88
89 procedure UPDATE_LINE_INFO(
90 V_LINE_ID IN NUMBER
91 , V_REQUESTED_CANCEL_QTY IN NUMBER
92 , V_CANCEL_COMMENT IN LONG
93 , V_CANCEL_CODE IN VARCHAR2
94 , V_FULL IN NUMBER
95 , V_OPTION_FLAG IN NUMBER
96 , V_PARENT_LINE_ID IN NUMBER
97 , V_LINE_TYPE_CODE IN VARCHAR2
98 , V_SHIPMENT_SCHEDULE_LINE_ID IN NUMBER
99 , V_SUBTREE_EXISTS IN NUMBER
100 , V_COMPONENT_CODE IN VARCHAR2
101 , V_REAL_PARENT_LINE_ID IN NUMBER
102 , V_LAST_UPDATED_BY IN NUMBER
103 , V_LAST_UPDATE_LOGIN IN NUMBER
104 , V_STATUS IN VARCHAR2
105 , V_RESULT OUT NUMBER
106 );
107
108 procedure UPDATE_MODEL_INFO(
109 V_LINE_ID IN NUMBER
110 , V_REQUESTED_CANCEL_QTY IN NUMBER
111 , V_CANCEL_COMMENT IN LONG
112 , V_CANCEL_CODE IN VARCHAR2
113 , V_STATUS IN VARCHAR2
114 , V_LAST_UPDATED_BY IN NUMBER
115 , V_LAST_UPDATE_LOGIN IN NUMBER
116 , V_HEADER_ID IN NUMBER
117 , V_FULL IN NUMBER
118 , V_RESULT OUT NUMBER
119 );
120
121 procedure LOAD_BOM(
122 V_SO_ORGANIZATION_ID IN NUMBER
123 , V_TOP_INVENTORY_ITEM_ID IN NUMBER
124 , V_TOP_COMPONENT_CODE IN VARCHAR2
125 , V_CREATION_DATE_TIME IN VARCHAR2
126 , V_LAST_UPDATED_BY IN NUMBER
127 , V_RESULT OUT NUMBER
128 );
129
130
131
132 procedure CHECK_MODEL_RATIOS(
133 V_LINE_ID IN NUMBER
134 , V_REQUESTED_CANCEL_QTY IN NUMBER
135 , V_LINE_TYPE_CODE IN VARCHAR2
136 , V_OPTION_FLAG IN NUMBER
137 , V_LINK_TO_LINE_ID IN NUMBER
138 , V_ORDER_QTY IN NUMBER
139 , V_CANCELLED_QTY IN NUMBER
140 , V_FULL IN NUMBER
141 , V_ATO_FLAG IN NUMBER
142 , V_SO_ORGANIZATION_ID IN NUMBER
143 , V_TOP_BILL_SEQUENCE_ID IN NUMBER
144 , V_PARENT_COMPONENT_SEQUENCE_ID IN NUMBER
145 , V_COMPONENT_SEQUENCE_ID IN NUMBER
146 , V_TOP_INVENTORY_ITEM_ID IN NUMBER
147 , V_TOP_COMPONENT_CODE IN VARCHAR2
148 , V_CREATION_DATE_TIME IN VARCHAR2
149 , V_LAST_UPDATED_BY IN NUMBER
150 , V_RESULT OUT NUMBER
151 );
152
153 END OE_CANCEL;