APPS.WSM_SERIAL_SUPPORT_PVT dependencies on WSM_SERIAL_TXN_TEMP

Line 7956: insert into wsm_serial_txn_temp

7952: END IF;
7953: ELSE
7954: l_stmt_num := 40;
7955:
7956: insert into wsm_serial_txn_temp
7957: (
7958: HEADER_ID ,
7959: TRANSACTION_TYPE_ID ,
7960: SERIAL_NUMBER ,

Line 8450: from wsm_serial_txn_temp wsti

8446: attribute12 ,
8447: attribute13 ,
8448: attribute14 ,
8449: attribute15
8450: from wsm_serial_txn_temp wsti
8451: where header_id IN (p_move_txn_id, p_scrap_txn_id)
8452: and transaction_type_id = 5;
8453:
8454:

Line 8863: delete from wsm_serial_txn_temp

8859: END LOOP;
8860:
8861: l_stmt_num := 310;
8862:
8863: delete from wsm_serial_txn_temp
8864: where header_id IN (p_move_txn_id,p_scrap_txn_id)
8865: and transaction_type_id = 5;
8866:
8867: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN

Line 9091: from wsm_serial_txn_temp

9087: attribute12 ,
9088: attribute13 ,
9089: attribute14 ,
9090: attribute15
9091: from wsm_serial_txn_temp
9092: where header_id = p_move_txn_id
9093: and transaction_type_id = 2
9094: and action_flag IN (5,6); -- select the move/scrap
9095:

Line 9248: -- Insert records into the WSM_SERIAL_TXN_TEMP for serial attributes...

9244: p_run_log_level => l_log_level
9245: );
9246: END IF;
9247:
9248: -- Insert records into the WSM_SERIAL_TXN_TEMP for serial attributes...
9249: WSM_Serial_support_PVT.Insert_move_attr ( p_group_id => null ,
9250: p_move_txn_id => p_move_txn_id ,
9251: p_scrap_txn_id => p_scrap_txn_id ,
9252: x_return_status => x_return_status ,