1 PACKAGE INV_ShortCheckExec_PVT AS
2 /* $Header: INVSEPVS.pls 120.3 2006/06/23 00:01:13 stdavid ship $*/
3 -- Start OF comments
4 -- API name : ExecCheck
5 -- TYPE : Private
6 -- Pre-reqs : None
7 -- FUNCTION :
8 -- Parameters:
9 -- IN :
10 -- p_api_version IN NUMBER (required)
11 -- API Version of this procedure
12 --
13 -- p_init_msg_list IN VARCHAR2 (optional)
14 -- DEFAULT = FND_API.G_FALSE,
15 --
16 -- p_commit IN VARCHAR2 (optional)
17 -- DEFAULT = FND_API.G_FALSE
18 --
19 --
20 -- OUT NOCOPY /* file.sql.39 change */ :
21 -- x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER
22 -- Result of all the operations
23 --
24 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
25 --
26 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
27 --
28 -- x_ErrorCode OUT NOCOPY /* file.sql.39 change */ NUMBER,
29 --
30 -- Version: Current Version 1.0
31 -- Changed : Nothing
32 -- No Previous Version 0.0
33 -- Initial version 1.0
34 -- Notes :
35 -- END OF comments
36 PROCEDURE ExecCheck (
37 p_api_version IN NUMBER ,
38 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
39 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40 x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
41 x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
42 x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
43 p_sum_detail_flag IN NUMBER,
44 p_organization_id IN NUMBER,
45 p_inventory_item_id IN NUMBER,
46 p_comp_att_qty_flag IN NUMBER,
47 p_primary_quantity IN NUMBER DEFAULT 0,
48 x_seq_num IN OUT NOCOPY /* file.sql.39 change */ NUMBER, -- Made the Parameter as IN for Bug 4399653
49 x_check_result OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50 );
51 -- Start OF comments
52 -- API name : CheckPrerequisites
53 -- TYPE : Private
54 -- Pre-reqs : None
55 -- FUNCTION :
56 -- Parameters:
57 -- IN :
58 -- p_api_version IN NUMBER (required)
59 -- API Version of this procedure
60 --
61 -- p_init_msg_list IN VARCHAR2 (optional)
62 -- DEFAULT = FND_API.G_FALSE,
63 --
64 -- p_commit IN VARCHAR2 (optional)
65 -- DEFAULT = FND_API.G_FALSE
66 --
67 --
68 -- OUT NOCOPY /* file.sql.39 change */ :
69 -- x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER
70 -- Result of all the operations
71 --
72 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
73 --
74 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75 --
76 -- Version: Current Version 1.0
77 -- Changed : Nothing
78 -- No Previous Version 0.0
79 -- Initial version 1.0
80 -- Notes :
81 -- END OF comments
82 PROCEDURE CheckPrerequisites (
83 p_api_version IN NUMBER ,
84 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
85 x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
86 x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
87 x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
88 p_sum_detail_flag IN NUMBER,
89 p_organization_id IN NUMBER,
90 p_inventory_item_id IN NUMBER,
91 p_transaction_type_id IN NUMBER,
92 x_check_result OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93 );
94 -- Start OF comments
95 -- API name : SendNotifications
96 -- TYPE : Private
97 -- Pre-reqs : None
98 -- FUNCTION :
99 -- Parameters:
100 -- IN :
101 -- p_api_version IN NUMBER (required)
102 -- API Version of this procedure
103 --
104 -- p_init_msg_list IN VARCHAR2 (optional)
105 -- DEFAULT = FND_API.G_FALSE,
106 --
107 -- p_commit IN VARCHAR2 (optional)
108 -- DEFAULT = FND_API.G_FALSE
109 --
110 --
111 -- OUT NOCOPY /* file.sql.39 change */ :
112 -- x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER
113 -- Result of all the operations
114 --
115 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
116 --
117 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
118 --
119 -- Version: Current Version 1.0
120 -- Changed : Nothing
121 -- No Previous Version 0.0
122 -- Initial version 1.0
123 -- Notes :
124 -- END OF comments
125 PROCEDURE SendNotifications (
126 p_api_version IN NUMBER ,
127 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
128 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
129 x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
130 x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
131 x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
132 p_organization_id IN NUMBER,
133 p_inventory_item_id IN NUMBER,
134 p_seq_num IN NUMBER,
135 p_notification_type IN VARCHAR2
136 );
137 -- Start OF comments
138 -- API name : PurgeTempTable
139 -- TYPE : Private
140 -- Pre-reqs : None
141 -- FUNCTION :
142 -- Parameters:
143 -- IN :
144 -- p_api_version IN NUMBER (required)
145 -- API Version of this procedure
146 --
147 -- p_init_msg_list IN VARCHAR2 (optional)
148 -- DEFAULT = FND_API.G_FALSE,
149 --
150 -- p_commit IN VARCHAR2 (optional)
151 -- DEFAULT = FND_API.G_FALSE
152 --
153 -- p_seq_num IN NUMBER
154 -- Sequence number of rows which have to be deleted
155 --
156 --
157 -- OUT NOCOPY /* file.sql.39 change */ :
158 -- x_return_status OUT NOCOPY /* file.sql.39 change */ NUMBER
159 -- Result of all the operations
160 --
161 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
162 --
163 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
164 --
165 -- x_ErrorCode OUT NOCOPY /* file.sql.39 change */ NUMBER,
166 --
167 --
168 -- Version: Current Version 1.0
169 -- Changed : Nothing
170 -- No Previous Version 0.0
171 -- Initial version 1.0
172 -- Notes :
173 -- END OF comments
174 PROCEDURE PurgeTempTable (
175 p_api_version IN NUMBER ,
176 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
177 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
178 x_return_status IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
179 x_msg_count IN OUT NOCOPY /* file.sql.39 change */ NUMBER,
180 x_msg_data IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
181 p_seq_num IN NUMBER
182 );
183 PROCEDURE PrepareMessage (
184 p_inventory_item_id IN NUMBER,
185 p_organization_id IN NUMBER
186 );
187 -- Added for bug 5081655: calculate open qty for repetitive schedules
188 FUNCTION get_rep_curr_open_qty
189 ( p_organization_id IN NUMBER
190 , p_wip_entity_id IN NUMBER
191 , p_repetitive_schedule_id IN NUMBER
192 , p_first_unit_start_date IN DATE
193 , p_processing_work_days IN NUMBER
194 , p_operation_seq_num IN NUMBER
195 , p_inventory_item_id IN NUMBER
196 , p_quantity_issued IN NUMBER
197 ) RETURN NUMBER;
198 END INV_ShortCheckExec_PVT;