APPS.WMS_TASK_MGMT_PUB dependencies on WMS_WAVEPLAN_TASKS_TEMP

Line 5371: FROM wms_waveplan_tasks_temp

5367:
5368: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5369: /* SELECT * BULK COLLECT
5370: INTO x_task_tab
5371: FROM wms_waveplan_tasks_temp
5372: WHERE transaction_temp_id = p_transaction_number;*/
5373:
5374: --Replacing the above by selecting columns from the table.
5375: SELECT

Line 5496: FROM wms_waveplan_tasks_temp

5492: PRIMARY_PRODUCT,
5493: LOAD_SEQ_NUMBER
5494: BULK COLLECT
5495: INTO x_task_tab
5496: FROM wms_waveplan_tasks_temp
5497: WHERE transaction_temp_id = p_transaction_number;
5498:
5499: END IF;
5500:

Line 5572: FROM wms_waveplan_tasks_temp

5568:
5569: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5570: /* SELECT * BULK COLLECT
5571: INTO x_task_tab
5572: FROM wms_waveplan_tasks_temp
5573: WHERE transaction_temp_id = p_transaction_number;*/
5574:
5575: --Replacing the above by selecting columns from the table.
5576: SELECT

Line 5697: FROM wms_waveplan_tasks_temp

5693: PRIMARY_PRODUCT,
5694: LOAD_SEQ_NUMBER
5695: BULK COLLECT
5696: INTO x_task_tab
5697: FROM wms_waveplan_tasks_temp
5698: WHERE transaction_temp_id = p_transaction_number;
5699:
5700: END IF;
5701:

Line 5946: FROM wms_waveplan_tasks_temp

5942: PRIMARY_PRODUCT,
5943: LOAD_SEQ_NUMBER
5944: BULK COLLECT
5945: INTO x_task_tab
5946: FROM wms_waveplan_tasks_temp
5947: WHERE transaction_temp_id = p_transaction_number;
5948: END IF;
5949: EXCEPTION
5950: WHEN NO_DATA_FOUND THEN

Line 6138: FROM wms_waveplan_tasks_temp

6134: PRIMARY_PRODUCT,
6135: LOAD_SEQ_NUMBER
6136: BULK COLLECT
6137: INTO x_task_tab
6138: FROM wms_waveplan_tasks_temp
6139: WHERE transaction_temp_id = p_transaction_number;
6140:
6141: END IF;
6142: EXCEPTION

Line 6429: FROM wms_waveplan_tasks_temp;*/

6425:
6426: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6427: /* SELECT * BULK COLLECT
6428: INTO x_task_tab
6429: FROM wms_waveplan_tasks_temp;*/
6430: --Replacing the above by selecting columns from the table.
6431: SELECT
6432: TASK_ID,
6433: TRANSACTION_TEMP_ID,

Line 6552: FROM wms_waveplan_tasks_temp;

6548: PRIMARY_PRODUCT,
6549: LOAD_SEQ_NUMBER
6550: BULK COLLECT
6551: INTO x_task_tab
6552: FROM wms_waveplan_tasks_temp;
6553: END IF;
6554:
6555: END IF; --- if l_execute_qry then
6556: