DBA Data[Home] [Help]

APPS.CSP_PARTS_REQUIREMENT dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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