13: g_pkg_name constant varchar2(30) := 'CSD_INTERNAL_ORDERS_PVT';
14:
15: PROCEDURE create_internal_requisition(
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19: p_product_txn_id IN NUMBER,
20: p_destination_ou IN NUMBER,
21: p_destination_org IN NUMBER,
14:
15: PROCEDURE create_internal_requisition(
16: p_api_version IN NUMBER,
17: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
18: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
19: p_product_txn_id IN NUMBER,
20: p_destination_ou IN NUMBER,
21: p_destination_org IN NUMBER,
22: p_destination_loc_id IN NUMBER,
34: /* Overloaded procedure: allows to batch a set of lines under same order */
35:
36: PROCEDURE create_internal_requisition(
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: p_product_txn_ids IN JTF_NUMBER_TABLE,
41: p_destination_ous IN JTF_NUMBER_TABLE,
42: p_destination_orgs IN JTF_NUMBER_TABLE,
35:
36: PROCEDURE create_internal_requisition(
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: p_product_txn_ids IN JTF_NUMBER_TABLE,
41: p_destination_ous IN JTF_NUMBER_TABLE,
42: p_destination_orgs IN JTF_NUMBER_TABLE,
43: p_destination_loc_ids IN JTF_NUMBER_TABLE,
85: );
86:
87: PROCEDURE pick_release_internal_order(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: p_product_txn_id IN NUMBER,
92: p_order_header_id IN NUMBER,
93: p_orig_quantity IN NUMBER,
86:
87: PROCEDURE pick_release_internal_order(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
91: p_product_txn_id IN NUMBER,
92: p_order_header_id IN NUMBER,
93: p_orig_quantity IN NUMBER,
94: p_shipped_quantity IN NUMBER,
108: x_return_status OUT NOCOPY VARCHAR2);
109:
110: PROCEDURE ship_confirm_internal_order(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
113: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: p_product_txn_id IN NUMBER,
115: p_order_header_id IN NUMBER,
116: p_orig_quantity IN NUMBER,
109:
110: PROCEDURE ship_confirm_internal_order(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
113: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
114: p_product_txn_id IN NUMBER,
115: p_order_header_id IN NUMBER,
116: p_orig_quantity IN NUMBER,
117: p_shipped_quantity IN NUMBER,
145: /* Called from : Internal move orders API. */
146: /* Input Parm : */
147: /* */
148: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
149: /* fnd_api.g_ret_sts_success (success) */
150: /* fnd_api.g_ret_sts_error (error) */
151: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
152: /*-----------------------------------------------------------------------------------------------------------*/
153:
146: /* Input Parm : */
147: /* */
148: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
149: /* fnd_api.g_ret_sts_success (success) */
150: /* fnd_api.g_ret_sts_error (error) */
151: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
152: /*-----------------------------------------------------------------------------------------------------------*/
153:
154: PROCEDURE RECEIVE_INTERNAL_ORDER(p_api_version IN NUMBER,
147: /* */
148: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be*/
149: /* fnd_api.g_ret_sts_success (success) */
150: /* fnd_api.g_ret_sts_error (error) */
151: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
152: /*-----------------------------------------------------------------------------------------------------------*/
153:
154: PROCEDURE RECEIVE_INTERNAL_ORDER(p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
151: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
152: /*-----------------------------------------------------------------------------------------------------------*/
153:
154: PROCEDURE RECEIVE_INTERNAL_ORDER(p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
156: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
157: p_product_txn_id IN NUMBER,
158: p_order_header_id IN NUMBER,
159: p_order_line_id IN NUMBER,
152: /*-----------------------------------------------------------------------------------------------------------*/
153:
154: PROCEDURE RECEIVE_INTERNAL_ORDER(p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
156: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
157: p_product_txn_id IN NUMBER,
158: p_order_header_id IN NUMBER,
159: p_order_line_id IN NUMBER,
160: p_receiving_subinv IN VARCHAR2 DEFAULT NULL, --swai: bug 14237315
170: /* Called from : Internal move orders API. */
171: /* Input Parm : */
172: /* */
173: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be */
174: /* fnd_api.g_ret_sts_success (success) */
175: /* fnd_api.g_ret_sts_error (error) */
176: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
177: /*-----------------------------------------------------------------------------------------------------------*/
178:
171: /* Input Parm : */
172: /* */
173: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be */
174: /* fnd_api.g_ret_sts_success (success) */
175: /* fnd_api.g_ret_sts_error (error) */
176: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
177: /*-----------------------------------------------------------------------------------------------------------*/
178:
179: PROCEDURE PICK_RELEASE(p_api_version IN NUMBER,
172: /* */
173: /* Output Parm : x_return_status VARCHAR2 Return status after the call. The status can be */
174: /* fnd_api.g_ret_sts_success (success) */
175: /* fnd_api.g_ret_sts_error (error) */
176: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
177: /*-----------------------------------------------------------------------------------------------------------*/
178:
179: PROCEDURE PICK_RELEASE(p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
176: /* fnd_api.g_ret_sts_unexp_error (unexpected) */
177: /*-----------------------------------------------------------------------------------------------------------*/
178:
179: PROCEDURE PICK_RELEASE(p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
181: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
182: p_product_txn_id IN NUMBER,
183: p_order_header_id IN NUMBER,
184: p_order_line_id IN NUMBER,
177: /*-----------------------------------------------------------------------------------------------------------*/
178:
179: PROCEDURE PICK_RELEASE(p_api_version IN NUMBER,
180: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
181: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
182: p_product_txn_id IN NUMBER,
183: p_order_header_id IN NUMBER,
184: p_order_line_id IN NUMBER,
185: p_fm_serial_num_tbl IN JTF_VARCHAR2_TABLE_100,