Pick Release API in Order Management

REM dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=pls \ REM dbdrv: checkfile:~PROD:~PATH:~FILE /*===========================================================================+ | Copyright (c) 1998 Oracle Corporation | | Redwood Shores, California, USA | | All rights reserved. | +===========================================================================*/ /*--------------------------------------------------------------------------+ | This package contains the Pick Release API specs. These APIs will be | | used to Pick Release Pick Wave Move Order Lines. | | History: | | August 25, 1999. David T. Santoro Created package spec. | +--------------------------------------------------------------------------*/ -- -- Copyright (c) 1996 Oracle Corporation, Redwood Shores, CA, USA -- All rights reserved. -- -- FILENAME -- -- INVPPICS.pls -- -- DESCRIPTION -- -- Spec of package INV_Pick_Release_PUB -- -- NOTES -- -- HISTORY -- -- 25-AUG-99 Created -- SET VERIFY OFF WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; CREATE or REPLACE PACKAGE INV_Pick_Release_PUB AS /* $Header: INVPPICS.pls 115.12.115100.2 2004/12/07 10:49:12 amohamme ship $ */ /*# * This package provides APIs used to Pick Release * Pick Wave Move Order Lines. * @rep:scope public * @rep:product INV * @rep:lifecycle active * @rep:displayname Inter-company transaction flow * @rep:category BUSINESS_ENTITY INV_PICK_RELEASE_PUB */ ------------------------------------------------------------------------------- -- Data Types ------------------------------------------------------------------------------- -- -- The Release Status table will notify the caller as to which Move Order Lines were -- successfully detailed, which ones were only partially detailed, and which ones -- failed to be processed at all. -- -- A table of this type will be returned by the Pick Release API to specify the -- status of the records it attempts to release. -- -- The records of this table (of type INV_RELEASE_STATUS_REC_TYPE) will consist of -- the following fields: -- mo_line_id => The Move Order Line ID that this status is for. -- return_status => The standard return status for an API. The return_status -- can also be 'P', which designates that the move order line was only -- partially detailed (but otherwise successful). TYPE INV_Release_Status_Rec_Type IS RECORD ( mo_line_id NUMBER, detail_rec_count NUMBER, return_status VARCHAR2(1) ); TYPE INV_Release_Status_Tbl_Type IS TABLE OF INV_Release_Status_Rec_Type INDEX BY BINARY_INTEGER; ------------------------------------------------------------------------------- -- Procedures and Functions ------------------------------------------------------------------------------- PROCEDURE test_sort(p_trolin_tbl IN OUT NOCOPY INV_Move_Order_Pub.Trolin_Tbl_Type); -- -- Name -- PROCEDURE Pick_Release -- -- Purpose -- Pick releases the move order lines passed in. -- -- Input Parameters -- p_api_version_number -- API version number (current version is 1.0) -- p_init_msg_list (optional, default FND_API.G_FALSE) -- Valid values: FND_API.G_FALSE or FND_API.G_TRUE. -- if set to FND_API.G_TRUE -- initialize error message list -- if set to FND_API.G_FALSE - not initialize error -- message list -- p_commit (optional, default FND_API.G_FALSE) -- whether or not to commit the changes to database -- -- p_mo_line_tbl -- Table of Move Order Line records to pick release -- p_auto_pick_confirm (optional, default 2) -- Overrides org-level parameter for whether to automatically call -- pick confirm after release -- Valid values: 1 (yes) or 2 (no) -- p_grouping_rule_id -- Overrides org-level and Move Order header-level grouping rule for -- generating pick slip numbers -- p_allow_partial_pick -- TRUE if the pick release process should continue after a line fails to -- be detailed completely. FALSE if the process should stop and roll -- back all changes if a line cannot be fully detailed. -- NOTE: Printing pick slips as the lines are detailed is only supported if -- this parameter is TRUE, since a commit must be done before printing. -- -- Output Parameters -- x_return_status -- if the pick release process succeeds, the value is -- fnd_api.g_ret_sts_success; -- if there is an expected error, the value is -- fnd_api.g_ret_sts_error; -- if there is an unexpected error, the value is -- fnd_api.g_ret_sts_unexp_error; -- x_msg_count -- if there is one or more errors, the number of error messages -- in the buffer -- x_msg_data -- if there is one and only one error, the error message -- (See fnd_api package for more details about the above output parameters) -- x_pick_release_status -- This output parameter is a table of records (of type -- INV_Release_Status_Tbl_Type) which specifies the pick release status -- for each move order line that is passed in. -- /*# * This API is used to pick release the move order lines passed in. * @param x_return_status return variable holding the status of the procedure call * @param x_msg_count return variable holding the number of error messages returned * @param x_msg_data return variable holding the error message * @param p_api_version API Version of this procedure. Current version is 1.0 * @param p_commit whether or not to commit the changes to database * @param p_mo_line_tbl Table of Move Order Line records to pick release * @param p_auto_pick_confirm Overrides org-level parameter for whether to automatically call pick confirm after release Valid values: 1 (yes) or 2 (no) * @param p_grouping_rule_id Overrides org-level and Move Order header-level grouping rule for generating pick slip numbers * @param p_allow_partial_pick if the process should stop and roll back all changes if a line cannot be fully detailed. * Printing pick slips as the lines are detailed is only supported if this parameter is TRUE, since a commit must be done before printing. * @param p_plan_tasks whether or not tasks should created and released * @param x_pick_release_status table of records (of type INV_Release_Status_Tbl_Type) which specifies the pick release status for each move order line that is passed in. * @rep:displayname Pick Release */ PROCEDURE Pick_Release ( p_api_version IN NUMBER ,p_init_msg_list IN VARCHAR2 := NULL ,p_commit IN VARCHAR2 := NULL ,x_return_status OUT NOCOPY VARCHAR2 ,x_msg_count OUT NOCOPY NUMBER ,x_msg_data OUT NOCOPY VARCHAR2 ,p_mo_line_tbl IN INV_Move_Order_PUB.TROLIN_TBL_TYPE ,p_auto_pick_confirm IN NUMBER := NULL ,p_grouping_rule_id IN NUMBER := NULL ,p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true ,x_pick_release_status OUT NOCOPY INV_Release_Status_Tbl_Type ,p_plan_tasks IN BOOLEAN := FALSE ); -- -- Name -- PROCEDURE Reserve_Unconfirmed_Quantity -- -- Purpose -- Transfers a reservation on material which is missing or damaged to an -- appropriate demand source. -- -- Input Parameters -- p_missing_quantity -- The quantity to be transferred to a Cycle Count reservation, in the primary -- UOM for the item. -- p_organization_id -- The organization in which the reservation(s) should be created -- p_reservation_id -- The reservation to transfer quantity from (not required if demand source -- parameters are given). -- p_demand_source_type_id -- The demand source type ID for the reservation to be transferred -- p_demand_source_header_id -- The demand source header ID for the reservation to be transferred -- p_demand_source_line_id -- The demand source line ID for the reservation to be transferred -- p_inventory_item_id -- The item which is missing or damaged. -- p_subinventory_code -- The subinventory in which the material is missing or damaged. -- p_locator_id -- The locator in which the material is missing or damaged. -- p_revision -- The revision of the item which is missing or damaged. -- p_lot_number -- The lot number of the item which is missing or damaged. -- -- Output Parameters -- x_return_status -- if the pick release process succeeds, the value is -- fnd_api.g_ret_sts_success; -- if there is an expected error, the value is -- fnd_api.g_ret_sts_error; -- if there is an unexpected error, the value is -- fnd_api.g_ret_sts_unexp_error; -- x_msg_count -- if there is one or more errors, the number of error messages -- in the buffer -- x_msg_data -- if there is one and only one error, the error message -- (See fnd_api package for more details about the above output parameters) -- /*# * This API is used to transfer a reservation on material which is missing or damaged * to an appropriate demand source. * @param x_return_status return variable holding the status of the procedure call * @param x_msg_count return variable holding the number of error messages returned * @param x_msg_data return variable holding the error message * @param p_api_version API Version of this procedure. Current version is 1.0 * @param p_commit whether or not to commit the changes to database * @param p_init_msg_list Indicates whether message stack is to be initialized * @param p_missing_quantity the quantity to be transferred in the primary UOM of the item * @param p_reservation_id the reservation to transfer quantity from (not required if demand source parameters are given) * @param p_demand_source_header_id the demand source header ID for the reservation to be transferred * @param p_demand_source_line_id the demand source line ID for the reservation to be transferred * @param p_organization_id the organization in which the reservation should be created * @param p_inventory_item_id the item which is missing or damaged * @param p_subinventory_code the subinventory in which the material is missing or damaged * @param p_locator_id the locator in which the material is missing or damaged * @param p_revision the revision of the material which is missing or damaged * @param p_lot_number the lot number of the material which is missing or damaged * @rep:displayname Reserve Unconfirmed Quantity */ PROCEDURE Reserve_Unconfirmed_Quantity ( p_api_version IN NUMBER ,p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false ,p_commit IN VARCHAR2 DEFAULT fnd_api.g_false ,x_return_status OUT NOCOPY VARCHAR2 ,x_msg_count OUT NOCOPY NUMBER ,x_msg_data OUT NOCOPY VARCHAR2 ,p_missing_quantity IN NUMBER ,p_reservation_id IN NUMBER DEFAULT fnd_api.g_miss_num ,p_demand_source_header_id IN NUMBER DEFAULT fnd_api.g_miss_num ,p_demand_source_line_id IN NUMBER DEFAULT fnd_api.g_miss_num ,p_organization_id IN NUMBER DEFAULT fnd_api.g_miss_num ,p_inventory_item_id IN NUMBER DEFAULT fnd_api.g_miss_num ,p_subinventory_code IN VARCHAR2 DEFAULT fnd_api.g_miss_char ,p_locator_id IN NUMBER DEFAULT fnd_api.g_miss_num ,p_revision IN VARCHAR2 DEFAULT fnd_api.g_miss_char ,p_lot_number IN VARCHAR2 DEFAULT fnd_api.g_miss_char ); /*# * This API is used to assign pick slip numbers to move order lines identified by the * move order header passed in. It is generally called after cartonization in a WMS enabled organization * @param x_return_status return variable holding the status of the procedure call * @param x_msg_count return variable holding the number of error messages returned * @param x_msg_data return variable holding the error message * @param p_move_order_header_id Identifies the move order header for which pick slip numbers will be assigned * @param p_ps_mode Pick slip print mode: I - Immediate, E - Deferred * @param p_grouping_rule_id Overrides organization move order header grouping rule for generating pick slip numbers * @param p_allow_partial_pick if the process should stop and roll back all changes if a line cannot be fully detailed. * Printing pick slips as the lines are detailed is only supported if this parameter is TRUE, since a commit must be done before printing. * @rep:displayname Assign Pick Slip Numbers */ PROCEDURE assign_pick_slip_number( x_return_status OUT NOCOPY VARCHAR2, x_msg_count OUT NOCOPY NUMBER, x_msg_data OUT NOCOPY VARCHAR2, p_move_order_header_id IN NUMBER DEFAULT 0, p_ps_mode IN VARCHAR2, p_grouping_rule_id IN NUMBER, p_allow_partial_pick IN VARCHAR2); END INV_Pick_Release_PUB; / --show errors; /* **show errors package body &PACKAGE_NAME ** **SELECT to_date('SQLERROR') FROM user_errors **WHERE name = '&PACKAGE_NAME' **AND type = 'PACKAGE BODY'; */ COMMIT; EXIT;