APPS.WMS_CONTAINER_PVT dependencies on WMS_LPN_PROCESS_TEMP

Line 3827: SELECT wms_lpn_process_temp_s.NEXTVAL

3823: p_lpn_out := l_gen_lpn_tbl(1).license_plate_number;
3824: ELSE
3825: -- More than one LPN was requested to be generated
3826: -- Generate a process ID number to tell which LPN's were generated
3827: SELECT wms_lpn_process_temp_s.NEXTVAL
3828: INTO p_process_id
3829: FROM DUAL;
3830:
3831: -- transfer to LPN bulk record of tables

Line 3835: mdebug('Inser into the WMS_LPN_PROCESS_TEMP procid='||p_process_id||' '||l_lpn_bulk_rec.lpn_id.first||'-'||l_lpn_bulk_rec.lpn_id.last , G_INFO);

3831: -- transfer to LPN bulk record of tables
3832: l_lpn_bulk_rec := To_LPNBulkRecType(l_gen_lpn_tbl);
3833:
3834: IF ( l_debug = 1 ) THEN
3835: mdebug('Inser into the WMS_LPN_PROCESS_TEMP procid='||p_process_id||' '||l_lpn_bulk_rec.lpn_id.first||'-'||l_lpn_bulk_rec.lpn_id.last , G_INFO);
3836: END IF;
3837:
3838: FORALL i in l_lpn_bulk_rec.lpn_id.first .. l_lpn_bulk_rec.lpn_id.last
3839: INSERT INTO wms_lpn_process_temp (

Line 3839: INSERT INTO wms_lpn_process_temp (

3835: mdebug('Inser into the WMS_LPN_PROCESS_TEMP procid='||p_process_id||' '||l_lpn_bulk_rec.lpn_id.first||'-'||l_lpn_bulk_rec.lpn_id.last , G_INFO);
3836: END IF;
3837:
3838: FORALL i in l_lpn_bulk_rec.lpn_id.first .. l_lpn_bulk_rec.lpn_id.last
3839: INSERT INTO wms_lpn_process_temp (
3840: process_id
3841: , lpn_id )
3842: VALUES (
3843: p_process_id

Line 6656: FROM wms_lpn_process_temp

6652: AND ROWNUM < 2;
6653:
6654: CURSOR container_lpn IS
6655: SELECT lpn_id
6656: FROM wms_lpn_process_temp
6657: WHERE process_id = l_process_id;
6658:
6659: CURSOR cartonization_cursor IS
6660: SELECT mmtt.cartonization_id,

Line 6823: FROM wms_lpn_process_temp

6819: END IF;
6820:
6821: SELECT COUNT(*)
6822: INTO temp
6823: FROM wms_lpn_process_temp
6824: WHERE process_id = l_process_id;
6825:
6826: IF (l_debug = 1) THEN
6827: mdebug('num lpn created: '|| TO_CHAR(temp), G_INFO);

Line 6992: SELECT wms_lpn_process_temp_s.NEXTVAL

6988: -- Cartonization does label printing disable pack label printing
6989: l_print_label := 2;
6990:
6991: -- Generate a process ID number to to insert LPNs into process temp table
6992: SELECT wms_lpn_process_temp_s.NEXTVAL
6993: INTO l_process_id
6994: FROM DUAL;
6995:
6996: IF (l_debug = 1) THEN

Line 7289: -- Insert the LPN created into the WMS_LPN_PROCESS_TEMP table

7285: END IF;
7286: END IF;
7287:
7288: IF (p_container_item_id IS NULL) THEN
7289: -- Insert the LPN created into the WMS_LPN_PROCESS_TEMP table
7290: IF (l_debug = 1) THEN
7291: mdebug('making insert to temp table', G_MESSAGE);
7292: END IF;
7293: INSERT INTO wms_lpn_process_temp ( process_id, lpn_id )

Line 7293: INSERT INTO wms_lpn_process_temp ( process_id, lpn_id )

7289: -- Insert the LPN created into the WMS_LPN_PROCESS_TEMP table
7290: IF (l_debug = 1) THEN
7291: mdebug('making insert to temp table', G_MESSAGE);
7292: END IF;
7293: INSERT INTO wms_lpn_process_temp ( process_id, lpn_id )
7294: VALUES ( l_process_id, l_lpn_to_pack);
7295: ELSE
7296: --Not through cartonization, need to insert Row for label printing
7297: l_input_param_rec.lpn_id := l_lpn_to_pack;

Line 7385: DELETE FROM wms_lpn_process_temp

7381: CLOSE container_lpn;
7382: END IF;
7383:
7384: -- Delete lpn entries from temp table
7385: DELETE FROM wms_lpn_process_temp
7386: WHERE process_id = l_process_id;
7387:
7388: -- Delete lpn entries from temp table
7389: IF (p_container_item_id IS NULL) THEN