DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT dependencies on FND_API

Line 145: --G_OPR_NONE CONSTANT VARCHAR2(30) := FND_API.G_MISS_CHAR;

141: G_OPR_UPDATE CONSTANT VARCHAR2(30) := 'UPDATE';
142: G_OPR_DELETE CONSTANT VARCHAR2(30) := 'DELETE';
143: G_OPR_LOCK CONSTANT VARCHAR2(30) := 'LOCK';
144: G_OPR_CANCEL CONSTANT VARCHAR2(30) := 'CANCEL';
145: --G_OPR_NONE CONSTANT VARCHAR2(30) := FND_API.G_MISS_CHAR;
146:
147: -- Address Types
148: G_ADDR_RESOURCE CONSTANT VARCHAR2(1) := 'R';
149: G_ADDR_CUSTOMER CONSTANT VARCHAR2(1) := 'C';

Line 154: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

150: G_ADDR_SPECIAL CONSTANT VARCHAR2(1) := 'S';
151:
152: PROCEDURE process_requirement
153: ( p_api_version IN NUMBER
154: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
155: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
156: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
157: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
158: ,p_create_order_flag IN VARCHAR2

Line 155: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

151:
152: PROCEDURE process_requirement
153: ( p_api_version IN NUMBER
154: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
155: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
156: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
157: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
158: ,p_create_order_flag IN VARCHAR2
159: ,x_return_status OUT NOCOPY VARCHAR2

Line 168: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

164: -- This procedure will be called from the parts requirement UI for creating orders
165: -- and updating the requirements table with the order details
166: PROCEDURE csptrreq_fm_order(
167: p_api_version IN NUMBER
168: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
169: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
170: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
171: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
172: ,x_return_status OUT NOCOPY VARCHAR2

Line 169: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

165: -- and updating the requirements table with the order details
166: PROCEDURE csptrreq_fm_order(
167: p_api_version IN NUMBER
168: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
169: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
170: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
171: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
172: ,x_return_status OUT NOCOPY VARCHAR2
173: ,x_msg_count OUT NOCOPY NUMBER

Line 179: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

175: );
176:
177: PROCEDURE csptrreq_order_res(
178: p_api_version IN NUMBER
179: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
180: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
181: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
182: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
183: ,x_return_status OUT NOCOPY VARCHAR2

Line 180: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

176:
177: PROCEDURE csptrreq_order_res(
178: p_api_version IN NUMBER
179: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
180: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
181: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
182: ,px_line_table IN OUT NOCOPY csp_parts_requirement.Line_Tbl_type
183: ,x_return_status OUT NOCOPY VARCHAR2
184: ,x_msg_count OUT NOCOPY NUMBER

Line 197: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

193: );
194:
195: PROCEDURE delete_rqmt_header(
196: p_api_version IN NUMBER
197: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
198: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
199: ,p_header_id IN NUMBER
200: ,x_return_status OUT NOCOPY VARCHAR2
201: ,x_msg_count OUT NOCOPY NUMBER

Line 198: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

194:
195: PROCEDURE delete_rqmt_header(
196: p_api_version IN NUMBER
197: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
198: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
199: ,p_header_id IN NUMBER
200: ,x_return_status OUT NOCOPY VARCHAR2
201: ,x_msg_count OUT NOCOPY NUMBER
202: ,x_msg_data OUT NOCOPY VARCHAR2

Line 207: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

203: );
204:
205: PROCEDURE save_rqmt_line(
206: p_api_version IN NUMBER
207: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
208: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
209: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
210: ,px_line_tbl IN OUT NOCOPY csp_parts_requirement.Line_tbl_type
211: ,x_return_status OUT NOCOPY VARCHAR2

Line 208: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

204:
205: PROCEDURE save_rqmt_line(
206: p_api_version IN NUMBER
207: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
208: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
209: ,px_header_rec IN OUT NOCOPY csp_parts_requirement.Header_rec_type
210: ,px_line_tbl IN OUT NOCOPY csp_parts_requirement.Line_tbl_type
211: ,x_return_status OUT NOCOPY VARCHAR2
212: ,x_msg_count OUT NOCOPY NUMBER

Line 218: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

214: );
215:
216: PROCEDURE delete_rqmt_line(
217: p_api_version IN NUMBER
218: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
219: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
220: ,p_line_tbl IN OUT NOCOPY csp_parts_requirement.Rqmt_Line_tbl_type
221: ,x_return_status OUT NOCOPY VARCHAR2
222: ,x_msg_count OUT NOCOPY NUMBER

Line 219: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

215:
216: PROCEDURE delete_rqmt_line(
217: p_api_version IN NUMBER
218: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
219: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
220: ,p_line_tbl IN OUT NOCOPY csp_parts_requirement.Rqmt_Line_tbl_type
221: ,x_return_status OUT NOCOPY VARCHAR2
222: ,x_msg_count OUT NOCOPY NUMBER
223: ,x_msg_data OUT NOCOPY VARCHAR2

Line 228: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

224: );
225:
226: PROCEDURE check_Availability(
227: p_api_version IN NUMBER
228: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
229: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
230: ,p_header_id IN NUMBER
231: ,x_line_Tbl OUT NOCOPY csp_parts_requirement.Line_tbl_type
232: ,x_avail_flag OUT NOCOPY VARCHAR2

Line 229: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

225:
226: PROCEDURE check_Availability(
227: p_api_version IN NUMBER
228: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
229: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
230: ,p_header_id IN NUMBER
231: ,x_line_Tbl OUT NOCOPY csp_parts_requirement.Line_tbl_type
232: ,x_avail_flag OUT NOCOPY VARCHAR2
233: ,x_return_status OUT NOCOPY VARCHAR2

Line 240: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE

236: );
237:
238: PROCEDURE create_order(
239: p_api_version IN NUMBER
240: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
241: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
242: ,p_header_id IN NUMBER
243: ,x_order_tbl OUT NOCOPY Order_Tbl_Type
244: ,x_return_status OUT NOCOPY VARCHAR2

Line 241: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

237:
238: PROCEDURE create_order(
239: p_api_version IN NUMBER
240: ,p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
241: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
242: ,p_header_id IN NUMBER
243: ,x_order_tbl OUT NOCOPY Order_Tbl_Type
244: ,x_return_status OUT NOCOPY VARCHAR2
245: ,x_msg_count OUT NOCOPY NUMBER