APPS.WMS_CONTAINER_PVT dependencies on WMS_LPN_PROCESS_TEMP

Line 4270: SELECT wms_lpn_process_temp_s.NEXTVAL

4266: p_lpn_out := l_gen_lpn_tbl(1).license_plate_number;
4267: ELSE
4268: -- More than one LPN was requested to be generated
4269: -- Generate a process ID number to tell which LPN's were generated
4270: SELECT wms_lpn_process_temp_s.NEXTVAL
4271: INTO p_process_id
4272: FROM DUAL;
4273:
4274: -- transfer to LPN bulk record of tables

Line 4278: 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);

4274: -- transfer to LPN bulk record of tables
4275: l_lpn_bulk_rec := To_LPNBulkRecType(l_gen_lpn_tbl);
4276:
4277: IF ( l_debug = 1 ) THEN
4278: 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);
4279: END IF;
4280:
4281: FORALL i in l_lpn_bulk_rec.lpn_id.first .. l_lpn_bulk_rec.lpn_id.last
4282: INSERT INTO wms_lpn_process_temp (

Line 4282: INSERT INTO wms_lpn_process_temp (

4278: 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);
4279: END IF;
4280:
4281: FORALL i in l_lpn_bulk_rec.lpn_id.first .. l_lpn_bulk_rec.lpn_id.last
4282: INSERT INTO wms_lpn_process_temp (
4283: process_id
4284: , lpn_id )
4285: VALUES (
4286: p_process_id

Line 7216: FROM wms_lpn_process_temp

7212: AND ROWNUM < 2;
7213:
7214: CURSOR container_lpn IS
7215: SELECT lpn_id
7216: FROM wms_lpn_process_temp
7217: WHERE process_id = l_process_id;
7218:
7219: CURSOR cartonization_cursor IS
7220: SELECT mmtt.cartonization_id,

Line 7383: FROM wms_lpn_process_temp

7379: END IF;
7380:
7381: SELECT COUNT(*)
7382: INTO temp
7383: FROM wms_lpn_process_temp
7384: WHERE process_id = l_process_id;
7385:
7386: IF (l_debug = 1) THEN
7387: mdebug('num lpn created: '|| TO_CHAR(temp), G_INFO);

Line 7552: SELECT wms_lpn_process_temp_s.NEXTVAL

7548: -- Cartonization does label printing disable pack label printing
7549: l_print_label := 2;
7550:
7551: -- Generate a process ID number to to insert LPNs into process temp table
7552: SELECT wms_lpn_process_temp_s.NEXTVAL
7553: INTO l_process_id
7554: FROM DUAL;
7555:
7556: IF (l_debug = 1) THEN

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

7845: END IF;
7846: END IF;
7847:
7848: IF (p_container_item_id IS NULL) THEN
7849: -- Insert the LPN created into the WMS_LPN_PROCESS_TEMP table
7850: IF (l_debug = 1) THEN
7851: mdebug('making insert to temp table', G_MESSAGE);
7852: END IF;
7853: INSERT INTO wms_lpn_process_temp ( process_id, lpn_id )

Line 7853: INSERT INTO wms_lpn_process_temp ( process_id, lpn_id )

7849: -- Insert the LPN created into the WMS_LPN_PROCESS_TEMP table
7850: IF (l_debug = 1) THEN
7851: mdebug('making insert to temp table', G_MESSAGE);
7852: END IF;
7853: INSERT INTO wms_lpn_process_temp ( process_id, lpn_id )
7854: VALUES ( l_process_id, l_lpn_to_pack);
7855: ELSE
7856: --Not through cartonization, need to insert Row for label printing
7857: l_input_param_rec.lpn_id := l_lpn_to_pack;

Line 7945: DELETE FROM wms_lpn_process_temp

7941: CLOSE container_lpn;
7942: END IF;
7943:
7944: -- Delete lpn entries from temp table
7945: DELETE FROM wms_lpn_process_temp
7946: WHERE process_id = l_process_id;
7947:
7948: -- Delete lpn entries from temp table
7949: IF (p_container_item_id IS NULL) THEN