[Home] [Help]
1: PACKAGE BODY WSH_CONTAINER_PUB AS
2: /* $Header: WSHCOPBB.pls 120.0 2005/05/26 17:16:10 appldev noship $ */
3:
4: -- standard global constants
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_CONTAINER_PUB';
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:
32: PROCEDURE Create_Containers (
33: -- Standard parameters
29: -- ids (delivery detail ids) along with the standard out parameters.
30: ------------------------------------------------------------------------------
31:
32: PROCEDURE Create_Containers (
33: -- Standard parameters
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
36: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
37: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
57: p_ucc_128_suffix_flag IN NUMBER
58: ) IS
59:
60:
61: -- Standard call to check for call compatibility
62: l_api_version CONSTANT NUMBER := 1.0;
63: l_api_name CONSTANT VARCHAR2(30):= 'Create_Containers';
64:
65:
84:
85:
86: BEGIN
87:
88: -- Standard begin of API savepoint
89: --
90: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
91: --
92: IF l_debug_on IS NULL
483: -- Procedure: Update_Container
484: --
485: -- Parameters: 1) container_rec - container record of type
486: -- wsh_delivery_details_pub.changedattributerectype
487: -- 2) other standard parameters
488: --
489: -- Description: This procedure takes in a record of container attributes that
490: -- contains the name and delivery detail id of container to update the
491: -- container record in WSH_DELIVERY_DETAILS with the attributes input in the
493: -- calls the wsh_delivery_details_pub.update_shipping_attributes public API.
494: ------------------------------------------------------------------------------
495:
496: PROCEDURE Update_Container (
497: -- Standard parameters
498: p_api_version IN NUMBER,
499: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
500: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
501: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
507: p_container_rec IN WSH_DELIVERY_DETAILS_PUB.CHANGEDATTRIBUTERECTYPE
508:
509: ) IS
510:
511: -- Standard call to check for call compatibility
512: l_api_version CONSTANT NUMBER := 1.0;
513: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
514:
515:
535:
536:
537: BEGIN
538:
539: -- Standard begin of API savepoint
540: --
541: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
542: --
543: IF l_debug_on IS NULL
702: -- containers that are created during the autopacking
703: -- 5) pack cont flag - a 'Y' or 'N' value to determine whether to
704: -- to autopack the detail containers that are created into
705: -- parent containers.
706: -- 6) other standard parameters
707: --
708: -- Description: This procedure takes in a table of ids of either delivery lines
709: -- or container or deliveries and autopacks the lines/containers/deliveries
710: -- into detail containers. The grouping id table is used only if the input
721: -- delivery detail ids.
722: ------------------------------------------------------------------------------
723:
724: PROCEDURE Auto_Pack (
725: -- Standard parameters
726: p_api_version IN NUMBER,
727: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
728: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
729: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
741: x_cont_inst_tab OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE
742:
743: ) IS
744:
745: -- Standard call to check for call compatibility
746: l_api_version CONSTANT NUMBER := 1.0;
747: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
748:
749: l_return_status VARCHAR2(30) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
777: WSH_INVALID_ENTITY_TYPE EXCEPTION;
778: WSH_FAIL_AUTOPACK EXCEPTION;
779:
780: BEGIN
781: -- Standard begin of API savepoint
782: --
783: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
784: --
785: IF l_debug_on IS NULL
1037: -- 7) delivery_name - name of delivery that container is being
1038: -- assigned to.
1039: -- 8) action_code - action code 'Pack', 'Assign', 'Unpack' or
1040: -- 'Unassign' to specify what action to perform.
1041: -- 9) other standard parameters
1042: --
1043: -- Description: This procedure takes in a table of delivery detail ids and
1044: -- name and/or delivery detail id of container to pack. If the action code is
1045: -- is assign then delivery id and delivery name must be specified. The API
1050: -- appropriate private APIs are called
1051: ------------------------------------------------------------------------------
1052:
1053: PROCEDURE Container_Actions (
1054: -- Standard parameters
1055: p_api_version IN NUMBER,
1056: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1057: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
1058: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
1071: p_action_code IN VARCHAR2
1072:
1073: ) IS
1074:
1075: -- Standard call to check for call compatibility
1076: l_api_version CONSTANT NUMBER := 1.0;
1077: l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
1078:
1079:
1095:
1096:
1097: BEGIN
1098:
1099: -- Standard begin of API savepoint
1100: --
1101: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1102: --
1103: IF l_debug_on IS NULL