[Home] [Help]
1: PACKAGE BODY WSH_CONTAINER_GRP AS
2: /* $Header: WSHCOGPB.pls 120.6.12010000.2 2008/08/04 12:29:32 suppal ship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CONTAINER_GRP';
6: p_message_type CONSTANT VARCHAR2(1) := 'E';
7:
8:
20: -- 9) num_digits - precision for number of digits
21: -- 10) quantity - number of containers
22: -- 11) container_name - container name if creating 1 container
23: -- 12) table of container ids - out table of ids
24: -- 13) other standard parameters
25: --
26: -- Description: This procedure takes in a container item id or container item
27: -- name and other necessary parameters to create one or more containers and
28: -- creates the required containers. It returns a table of container instance
25: --
26: -- Description: This procedure takes in a container item id or container item
27: -- name and other necessary parameters to create one or more containers and
28: -- creates the required containers. It returns a table of container instance
29: -- ids (delivery detail ids) along with the standard out parameters.
30: --
31: -- THIS PROCEDURE SHOULD NOT BE USED ANYMORE, IT IS USED ONLY FOR BACKWARD
32: -- COMPATIBILITY.
33: --
33: --
34: ------------------------------------------------------------------------------
35:
36: PROCEDURE Create_Containers (
37: -- Standard parameters
38: p_api_version IN NUMBER,
39: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
40: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
41: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
62: p_caller IN VARCHAR2 -- Has default 'WMS' in spec
63: ) IS
64:
65:
66: -- Standard call to check for call compatibility
67: l_api_version CONSTANT NUMBER := 1.0;
68: l_api_name CONSTANT VARCHAR2(30):= 'Create_Containers';
69:
70: l_return_status VARCHAR2(30) := NULL;
112: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_CONTAINERS';
113: --
114: BEGIN
115:
116: -- Standard begin of API savepoint
117: --
118: -- Debug Statements
119: --
120: --
433: -- Procedure: Update_Container
434: --
435: -- Parameters: 1) container_rec - container record of type
436: -- wsh_interface.changedattributerectype
437: -- 2) other standard parameters
438: --
439: -- Description: This procedure takes in a record of container attributes that
440: -- contains the name and delivery detail id of container to update the
441: -- container record in WSH_DELIVERY_DETAILS with the attributes input in the
446: -- COMPATIBILITY.
447: ------------------------------------------------------------------------------
448:
449: PROCEDURE Update_Container (
450: -- Standard parameters
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
453: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
454: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
460: p_container_rec IN WSH_CONTAINER_GRP.CHANGEDATTRIBUTETABTYPE
461:
462: ) IS
463:
464: -- Standard call to check for call compatibility
465: l_api_version CONSTANT NUMBER := 1.0;
466: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
467:
468: l_return_status VARCHAR2(30) := NULL;
520: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_CONTAINER';
521: --
522: BEGIN
523:
524: -- Standard begin of API savepoint
525: --
526: -- Debug Statements
527: --
528: --
1040: -- containers that are created during the autopacking
1041: -- 5) pack cont flag - a 'Y' or 'N' value to determine whether to
1042: -- to autopack the detail containers that are created into
1043: -- parent containers.
1044: -- 6) other standard parameters
1045: --
1046: -- Description: This procedure takes in a table of ids of either delivery lines
1047: -- or container or deliveries and autopacks the lines/containers/deliveries
1048: -- into detail containers. The grouping id table is used only if the input
1059: -- delivery detail ids.
1060: ------------------------------------------------------------------------------
1061:
1062: PROCEDURE Auto_Pack (
1063: -- Standard parameters
1064: p_api_version IN NUMBER,
1065: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1066: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1067: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1079: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE
1080:
1081: ) IS
1082:
1083: -- Standard call to check for call compatibility
1084: l_api_version CONSTANT NUMBER := 1.0;
1085: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
1086:
1087: l_return_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1159: WSH_UTIL_CORE.G_START_OF_SESSION_API := l_api_session_name;
1160: WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API := FALSE;
1161: END IF;
1162:
1163: -- Standard begin of API savepoint
1164: --
1165: -- Debug Statements
1166: --
1167: --
1921: -- 7) delivery_name - name of delivery that container is being
1922: -- assigned to.
1923: -- 8) action_code - action code 'Pack', 'Assign', 'Unpack' or
1924: -- 'Unassign' to specify what action to perform.
1925: -- 9) other standard parameters
1926: --
1927: -- Description: This procedure takes in a table of delivery detail ids and
1928: -- name and/or delivery detail id of container to pack. If the action code is
1929: -- is assign then delivery id and delivery name must be specified. The API
1940:
1941:
1942:
1943: PROCEDURE Container_Actions (
1944: -- Standard parameters
1945: p_api_version IN NUMBER,
1946: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1947: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1948: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1960: p_action_code IN VARCHAR2 ,
1961: p_caller IN VARCHAR2 DEFAULT 'WMS'
1962:
1963: ) IS
1964: -- Standard call to check for call compatibility
1965: l_api_version CONSTANT NUMBER := 1.0;
1966: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
1967:
1968: l_detail_tab WSH_UTIL_CORE.ID_TAB_TYPE;