APPS.INV_CYC_LOVS dependencies on WMS_PICKING_PKG

Line 1504: print_debug ( 'Update the wms_picking_pkg.g_previous_task_status table.' );

1500: END IF;
1501:
1502: -- bug 10298222 start
1503: IF ( l_debug = 1 ) THEN
1504: print_debug ( 'Update the wms_picking_pkg.g_previous_task_status table.' );
1505: END IF;
1506: BEGIN
1507: SELECT transaction_temp_id into l_temp_cc_id
1508: FROM wms_dispatched_tasks wdt

Line 1511: wms_picking_pkg.g_previous_task_status(g_cc_entry.cycle_count_entry_id) := 2; --WDT exists, so mark as QUEUED

1507: SELECT transaction_temp_id into l_temp_cc_id
1508: FROM wms_dispatched_tasks wdt
1509: WHERE wdt.transaction_temp_id = g_cc_entry.cycle_count_entry_id;
1510:
1511: wms_picking_pkg.g_previous_task_status(g_cc_entry.cycle_count_entry_id) := 2; --WDT exists, so mark as QUEUED
1512: EXCEPTION
1513: WHEN NO_DATA_FOUND THEN
1514: wms_picking_pkg.g_previous_task_status(g_cc_entry.cycle_count_entry_id) := 1; --no WDT, so mark as PENDING
1515: END;

Line 1514: wms_picking_pkg.g_previous_task_status(g_cc_entry.cycle_count_entry_id) := 1; --no WDT, so mark as PENDING

1510:
1511: wms_picking_pkg.g_previous_task_status(g_cc_entry.cycle_count_entry_id) := 2; --WDT exists, so mark as QUEUED
1512: EXCEPTION
1513: WHEN NO_DATA_FOUND THEN
1514: wms_picking_pkg.g_previous_task_status(g_cc_entry.cycle_count_entry_id) := 1; --no WDT, so mark as PENDING
1515: END;
1516: -- bug 10298222 end
1517: END update_row;
1518:

Line 9797: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);

9793: -- The idea is to delete WDT for task with prev status as 'Pending'
9794: -- and update the WDT for task with prev status as 'Queued'
9795:
9796: BEGIN
9797: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);
9798: wms_picking_pkg.g_previous_task_status.delete(p_transaction_temp_id);
9799: EXCEPTION
9800: WHEN OTHERS THEN
9801: print_debug('wms_picking_pkg.g_previous_task_status(p_transaction_temp_id) : ' || p_transaction_temp_id

Line 9798: wms_picking_pkg.g_previous_task_status.delete(p_transaction_temp_id);

9794: -- and update the WDT for task with prev status as 'Queued'
9795:
9796: BEGIN
9797: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);
9798: wms_picking_pkg.g_previous_task_status.delete(p_transaction_temp_id);
9799: EXCEPTION
9800: WHEN OTHERS THEN
9801: print_debug('wms_picking_pkg.g_previous_task_status(p_transaction_temp_id) : ' || p_transaction_temp_id
9802: || ' : not found' );

Line 9801: print_debug('wms_picking_pkg.g_previous_task_status(p_transaction_temp_id) : ' || p_transaction_temp_id

9797: l_prev_task_status := wms_picking_pkg.g_previous_task_status(p_transaction_temp_id);
9798: wms_picking_pkg.g_previous_task_status.delete(p_transaction_temp_id);
9799: EXCEPTION
9800: WHEN OTHERS THEN
9801: print_debug('wms_picking_pkg.g_previous_task_status(p_transaction_temp_id) : ' || p_transaction_temp_id
9802: || ' : not found' );
9803: l_prev_task_status := 1; --PENDING
9804: END ;
9805:

Line 9991: wms_picking_pkg.g_previous_task_status(l_transaction_temp_id) := 2;

9987: WHERE exists (SELECT 1
9988: FROM wms_dispatched_tasks t
9989: WHERE t.transaction_temp_id = l_transaction_temp_id);
9990:
9991: wms_picking_pkg.g_previous_task_status(l_transaction_temp_id) := 2;
9992: EXCEPTION
9993: WHEN NO_DATA_FOUND THEN
9994: l_wdt_rowcnt := 0;
9995: wms_picking_pkg.g_previous_task_status(l_transaction_temp_id) := 1;

Line 9995: wms_picking_pkg.g_previous_task_status(l_transaction_temp_id) := 1;

9991: wms_picking_pkg.g_previous_task_status(l_transaction_temp_id) := 2;
9992: EXCEPTION
9993: WHEN NO_DATA_FOUND THEN
9994: l_wdt_rowcnt := 0;
9995: wms_picking_pkg.g_previous_task_status(l_transaction_temp_id) := 1;
9996: END;
9997:
9998: SELECT "ROLE",
9999: equipment,