APPS.WMS_TASK_MGMT_PUB dependencies on WMS_WAVEPLAN_TASKS_TEMP

Line 5462: FROM wms_waveplan_tasks_temp

5458:
5459: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5460: /* SELECT * BULK COLLECT
5461: INTO x_task_tab
5462: FROM wms_waveplan_tasks_temp
5463: WHERE transaction_temp_id = p_transaction_number;*/
5464:
5465: --Replacing the above by selecting columns from the table.
5466: SELECT

Line 5587: FROM wms_waveplan_tasks_temp

5583: PRIMARY_PRODUCT,
5584: LOAD_SEQ_NUMBER
5585: BULK COLLECT
5586: INTO x_task_tab
5587: FROM wms_waveplan_tasks_temp
5588: WHERE transaction_temp_id = p_transaction_number;
5589:
5590: END IF;
5591:

Line 5664: FROM wms_waveplan_tasks_temp

5660:
5661: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5662: /* SELECT * BULK COLLECT
5663: INTO x_task_tab
5664: FROM wms_waveplan_tasks_temp
5665: WHERE transaction_temp_id = p_transaction_number;*/
5666:
5667: --Replacing the above by selecting columns from the table.
5668: SELECT

Line 5789: FROM wms_waveplan_tasks_temp

5785: PRIMARY_PRODUCT,
5786: LOAD_SEQ_NUMBER
5787: BULK COLLECT
5788: INTO x_task_tab
5789: FROM wms_waveplan_tasks_temp
5790: WHERE transaction_temp_id = p_transaction_number;
5791:
5792: END IF;
5793:

Line 6040: FROM wms_waveplan_tasks_temp

6036: PRIMARY_PRODUCT,
6037: LOAD_SEQ_NUMBER
6038: BULK COLLECT
6039: INTO x_task_tab
6040: FROM wms_waveplan_tasks_temp
6041: WHERE transaction_temp_id = p_transaction_number;
6042: END IF;
6043: EXCEPTION
6044: WHEN NO_DATA_FOUND THEN

Line 6233: FROM wms_waveplan_tasks_temp

6229: PRIMARY_PRODUCT,
6230: LOAD_SEQ_NUMBER
6231: BULK COLLECT
6232: INTO x_task_tab
6233: FROM wms_waveplan_tasks_temp
6234: WHERE transaction_temp_id = p_transaction_number;
6235:
6236: END IF;
6237: EXCEPTION

Line 6524: FROM wms_waveplan_tasks_temp;*/

6520:
6521: IF(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6522: /* SELECT * BULK COLLECT
6523: INTO x_task_tab
6524: FROM wms_waveplan_tasks_temp;*/
6525: --Replacing the above by selecting columns from the table.
6526: SELECT
6527: TASK_ID,
6528: TRANSACTION_TEMP_ID,

Line 6647: FROM wms_waveplan_tasks_temp;

6643: PRIMARY_PRODUCT,
6644: LOAD_SEQ_NUMBER
6645: BULK COLLECT
6646: INTO x_task_tab
6647: FROM wms_waveplan_tasks_temp;
6648: END IF;
6649:
6650: END IF; --- if l_execute_qry then
6651: