19: -- p_status_id input status id
20: -- p_transaction_type_id input transaction_type
21: --
22: -- Output Parameters
23: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
24: -- = fnd_api.g_ret_sts_exc_error, if an expected
25: -- error occurred
26: -- = fnd_api.g_ret_sts_unexp_error, if
27: -- an unexpected error occurred
20: -- p_transaction_type_id input transaction_type
21: --
22: -- Output Parameters
23: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
24: -- = fnd_api.g_ret_sts_exc_error, if an expected
25: -- error occurred
26: -- = fnd_api.g_ret_sts_unexp_error, if
27: -- an unexpected error occurred
28: --
22: -- Output Parameters
23: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
24: -- = fnd_api.g_ret_sts_exc_error, if an expected
25: -- error occurred
26: -- = fnd_api.g_ret_sts_unexp_error, if
27: -- an unexpected error occurred
28: --
29: -- x_msg_count Number of error message in the error message
30: -- list
115: -- p_organization_id organization the item resides in
116: -- p_inventory_item_id given item id we query for
117: --
118: -- Output Parameters
119: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
120: -- = fnd_api.g_ret_sts_exc_error, if an expected
121: -- error occurred
122: -- = fnd_api.g_ret_sts_unexp_error, if
123: -- an unexpected error occurred
116: -- p_inventory_item_id given item id we query for
117: --
118: -- Output Parameters
119: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
120: -- = fnd_api.g_ret_sts_exc_error, if an expected
121: -- error occurred
122: -- = fnd_api.g_ret_sts_unexp_error, if
123: -- an unexpected error occurred
124: --
118: -- Output Parameters
119: -- x_return_status = fnd_api.g_ret_sts_success, if succeeded
120: -- = fnd_api.g_ret_sts_exc_error, if an expected
121: -- error occurred
122: -- = fnd_api.g_ret_sts_unexp_error, if
123: -- an unexpected error occurred
124: --
125: -- x_msg_count Number of error message in the error message
126: -- list
259: -- Input Paramters
260: -- p_api_version_number API version number (current version is 1.0)
261: -- p_init_msg_lst Whether initialize the error message list or
262: -- not.
263: -- Should be fnd_api.g_false or fnd_api.g_true
264: -- p_update_method update method, refer to the global constant
265: -- definition in INVMSPUB.pls
266: -- p_status_id status_id which should be changed to
267: -- p_organization_id organization the item resides in
283:
284: ----------------------------------------------------------------------------------------
285: PROCEDURE update_status
286: ( p_api_version_number IN NUMBER
287: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
288: , x_return_status OUT NOCOPY VARCHAR2
289: , x_msg_count OUT NOCOPY NUMBER
290: , x_msg_data OUT NOCOPY VARCHAR2
291: , p_update_method IN NUMBER