DBA Data[Home] [Help]

APPS.CSD_INTERNAL_ORDERS_PVT dependencies on FND_API

Line 17: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 18: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 38: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 39: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 89: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 90: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 112: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 113: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

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,

Line 149: /* fnd_api.g_ret_sts_success (success) */

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:

Line 150: /* fnd_api.g_ret_sts_error (error) */

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,

Line 151: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

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,

Line 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,

Line 156: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

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

Line 174: /* fnd_api.g_ret_sts_success (success) */

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:

Line 175: /* fnd_api.g_ret_sts_error (error) */

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,

Line 176: /* fnd_api.g_ret_sts_unexp_error (unexpected) */

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,

Line 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,

Line 181: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

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,