APPS.WMS_CONTAINER_PVT dependencies on WMS_CONTAINER_PUB

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

880: END IF;
881: END IF;
882:
883: -- LPN Context cannot be null
884: p_lpn_table(i).lpn_context := NVL(p_lpn_table(i).lpn_context, WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED);
885:
886: -- If context is pregenerated, do not allow sub and loc info
887: IF ( p_lpn_table(i).lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED ) THEN
888: p_lpn_table(i).subinventory_code := NULL;

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

883: -- LPN Context cannot be null
884: p_lpn_table(i).lpn_context := NVL(p_lpn_table(i).lpn_context, WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED);
885:
886: -- If context is pregenerated, do not allow sub and loc info
887: IF ( p_lpn_table(i).lpn_context = WMS_CONTAINER_PUB.LPN_CONTEXT_PREGENERATED ) THEN
888: p_lpn_table(i).subinventory_code := NULL;
889: p_lpn_table(i).locator_id := NULL;
890: END IF;
891:

Line 4642: l_lpn WMS_CONTAINER_PUB.LPN;

4638:
4639: l_tmp_bulk_lpns LPNBulkRecType;
4640: l_tmp_i NUMBER;
4641:
4642: l_lpn WMS_CONTAINER_PUB.LPN;
4643: l_content_lpn WMS_CONTAINER_PUB.LPN;
4644: l_wt_vol_new WMS_CONTAINER_PUB.LPN;
4645:
4646: l_result NUMBER;

Line 4643: l_content_lpn WMS_CONTAINER_PUB.LPN;

4639: l_tmp_bulk_lpns LPNBulkRecType;
4640: l_tmp_i NUMBER;
4641:
4642: l_lpn WMS_CONTAINER_PUB.LPN;
4643: l_content_lpn WMS_CONTAINER_PUB.LPN;
4644: l_wt_vol_new WMS_CONTAINER_PUB.LPN;
4645:
4646: l_result NUMBER;
4647: l_serial_summary_entry NUMBER := 2;

Line 4644: l_wt_vol_new WMS_CONTAINER_PUB.LPN;

4640: l_tmp_i NUMBER;
4641:
4642: l_lpn WMS_CONTAINER_PUB.LPN;
4643: l_content_lpn WMS_CONTAINER_PUB.LPN;
4644: l_wt_vol_new WMS_CONTAINER_PUB.LPN;
4645:
4646: l_result NUMBER;
4647: l_serial_summary_entry NUMBER := 2;
4648:

Line 6428: , p_lpn IN WMS_CONTAINER_PUB.LPN

6424: , p_validation_level IN NUMBER := fnd_api.g_valid_level_full
6425: , x_return_status OUT NOCOPY VARCHAR2
6426: , x_msg_count OUT NOCOPY NUMBER
6427: , x_msg_data OUT NOCOPY VARCHAR2
6428: , p_lpn IN WMS_CONTAINER_PUB.LPN
6429: , p_caller IN VARCHAR2 := NULL
6430: ) IS
6431: l_api_name CONSTANT VARCHAR2(30) := 'Modify_LPN';
6432: l_api_version CONSTANT NUMBER := 1.0;

Line 8163: , x_content_tbl OUT NOCOPY WMS_CONTAINER_PUB.WMS_Container_Tbl_Type

8159: , x_msg_count OUT NOCOPY NUMBER
8160: , x_msg_data OUT NOCOPY VARCHAR2
8161: , p_lpn_id IN NUMBER
8162: , p_explosion_level IN NUMBER := 0
8163: , x_content_tbl OUT NOCOPY WMS_CONTAINER_PUB.WMS_Container_Tbl_Type
8164: ) IS
8165: l_api_name CONSTANT VARCHAR2(30) := 'Explode_LPN';
8166: l_api_version CONSTANT NUMBER := 1.0;
8167: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

Line 8174: l_container_content_rec WMS_CONTAINER_PUB.WMS_Container_Content_Rec_Type;

8170:
8171: l_counter NUMBER := 1; -- Counter variable initialized to 1
8172: l_current_lpn NUMBER;
8173: l_temp_uom_code VARCHAR2(3);
8174: l_container_content_rec WMS_CONTAINER_PUB.WMS_Container_Content_Rec_Type;
8175:
8176: CURSOR nested_lpn_cursor IS
8177: SELECT lpn_id, parent_lpn_id, inventory_item_id, organization_id,
8178: revision, lot_number, serial_number, cost_group_id

Line 8448: p_lpn IN OUT nocopy WMS_CONTAINER_PUB.LPN

8444: -- ----------------------------------------------------------------------------------
8445: -- ----------------------------------------------------------------------------------
8446:
8447: FUNCTION Validate_LPN (
8448: p_lpn IN OUT nocopy WMS_CONTAINER_PUB.LPN
8449: , p_lock IN NUMBER := 2
8450: ) RETURN NUMBER IS
8451: l_api_name CONSTANT VARCHAR2(30) := 'Validate_LPN';
8452: l_api_version CONSTANT NUMBER := 1.0;

Line 8714: l_contents_tbl WMS_CONTAINER_PUB.WMS_CONTAINER_TBL_TYPE;

8710: l_api_version CONSTANT NUMBER := 1.0;
8711: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
8712: l_progress VARCHAR2(10) := '0';
8713:
8714: l_contents_tbl WMS_CONTAINER_PUB.WMS_CONTAINER_TBL_TYPE;
8715: l_return_status NUMBER;
8716: l_trx_tmp_id NUMBER;
8717: l_ser_tmp_id NUMBER;
8718: l_trx_hdr_id NUMBER;