APPS.WMS_CONTAINER_PVT dependencies on WMS_CONTAINER_PUB

Line 829: p_lpn_table(i).lpn_context := NVL(p_lpn_table(i).lpn_context, WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED);

825: END IF;
826: END IF;
827:
828: -- LPN Context cannot be null
829: p_lpn_table(i).lpn_context := NVL(p_lpn_table(i).lpn_context, WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED);
830:
831: -- If context is pregenerated, do not allow sub and loc info
832: IF ( p_lpn_table(i).lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED ) THEN
833: p_lpn_table(i).subinventory_code := NULL;

Line 832: IF ( p_lpn_table(i).lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED ) THEN

828: -- LPN Context cannot be null
829: p_lpn_table(i).lpn_context := NVL(p_lpn_table(i).lpn_context, WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED);
830:
831: -- If context is pregenerated, do not allow sub and loc info
832: IF ( p_lpn_table(i).lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED ) THEN
833: p_lpn_table(i).subinventory_code := NULL;
834: p_lpn_table(i).locator_id := NULL;
835: END IF;
836:

Line 4200: l_lpn WMS_CONTAINER_PUB.LPN;

4196:
4197: l_tmp_bulk_lpns LPNBulkRecType;
4198: l_tmp_i NUMBER;
4199:
4200: l_lpn WMS_CONTAINER_PUB.LPN;
4201: l_content_lpn WMS_CONTAINER_PUB.LPN;
4202: l_wt_vol_new WMS_CONTAINER_PUB.LPN;
4203:
4204: l_result NUMBER;

Line 4201: l_content_lpn WMS_CONTAINER_PUB.LPN;

4197: l_tmp_bulk_lpns LPNBulkRecType;
4198: l_tmp_i NUMBER;
4199:
4200: l_lpn WMS_CONTAINER_PUB.LPN;
4201: l_content_lpn WMS_CONTAINER_PUB.LPN;
4202: l_wt_vol_new WMS_CONTAINER_PUB.LPN;
4203:
4204: l_result NUMBER;
4205: l_serial_summary_entry NUMBER := 2;

Line 4202: l_wt_vol_new WMS_CONTAINER_PUB.LPN;

4198: l_tmp_i NUMBER;
4199:
4200: l_lpn WMS_CONTAINER_PUB.LPN;
4201: l_content_lpn WMS_CONTAINER_PUB.LPN;
4202: l_wt_vol_new WMS_CONTAINER_PUB.LPN;
4203:
4204: l_result NUMBER;
4205: l_serial_summary_entry NUMBER := 2;
4206:

Line 5868: , p_lpn IN WMS_CONTAINER_PUB.LPN

5864: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
5865: , x_return_status OUT NOCOPY VARCHAR2
5866: , x_msg_count OUT NOCOPY NUMBER
5867: , x_msg_data OUT NOCOPY VARCHAR2
5868: , p_lpn IN WMS_CONTAINER_PUB.LPN
5869: , p_caller IN VARCHAR2 := NULL
5870: ) IS
5871: l_api_name CONSTANT VARCHAR2(30) := 'Modify_LPN';
5872: l_api_version CONSTANT NUMBER := 1.0;

Line 7603: , x_content_tbl OUT NOCOPY WMS_CONTAINER_PUB.WMS_Container_Tbl_Type

7599: , x_msg_count OUT NOCOPY NUMBER
7600: , x_msg_data OUT NOCOPY VARCHAR2
7601: , p_lpn_id IN NUMBER
7602: , p_explosion_level IN NUMBER := 0
7603: , x_content_tbl OUT NOCOPY WMS_CONTAINER_PUB.WMS_Container_Tbl_Type
7604: ) IS
7605: l_api_name CONSTANT VARCHAR2(30) := 'Explode_LPN';
7606: l_api_version CONSTANT NUMBER := 1.0;
7607: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 7614: l_container_content_rec WMS_CONTAINER_PUB.WMS_Container_Content_Rec_Type;

7610:
7611: l_counter NUMBER := 1; -- Counter variable initialized to 1
7612: l_current_lpn NUMBER;
7613: l_temp_uom_code VARCHAR2(3);
7614: l_container_content_rec WMS_CONTAINER_PUB.WMS_Container_Content_Rec_Type;
7615:
7616: CURSOR nested_lpn_cursor IS
7617: SELECT lpn_id, parent_lpn_id, inventory_item_id, organization_id,
7618: revision, lot_number, serial_number, cost_group_id

Line 7883: p_lpn IN OUT nocopy WMS_CONTAINER_PUB.LPN

7879: -- ----------------------------------------------------------------------------------
7880: -- ----------------------------------------------------------------------------------
7881:
7882: FUNCTION Validate_LPN (
7883: p_lpn IN OUT nocopy WMS_CONTAINER_PUB.LPN
7884: , p_lock IN NUMBER := 2
7885: ) RETURN NUMBER IS
7886: l_api_name CONSTANT VARCHAR2(30) := 'Validate_LPN';
7887: l_api_version CONSTANT NUMBER := 1.0;

Line 8143: l_contents_tbl WMS_CONTAINER_PUB.WMS_CONTAINER_TBL_TYPE;

8139: l_api_version CONSTANT NUMBER := 1.0;
8140: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8141: l_progress VARCHAR2(10) := '0';
8142:
8143: l_contents_tbl WMS_CONTAINER_PUB.WMS_CONTAINER_TBL_TYPE;
8144: l_return_status NUMBER;
8145: l_trx_tmp_id NUMBER;
8146: l_ser_tmp_id NUMBER;
8147: l_trx_hdr_id NUMBER;