APPS.INV_CYC_LOVS dependencies on WMS_DISPATCHED_TASKS

Line 339: FROM wms_dispatched_tasks

335: END IF;
336:
337: SELECT COUNT ( * )
338: INTO l_dispatched_count
339: FROM wms_dispatched_tasks
340: WHERE task_type = 3
341: AND organization_id = p_organization_id
342: AND transaction_temp_id = l_dispatched_task
343: AND person_id <> NVL ( g_employee_id, -999 );

Line 843: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt

839:
840: CURSOR cc_entry_cursor
841: IS
842: SELECT cycle_count_entry_id
843: FROM mtl_cycle_count_entries mcce, wms_dispatched_tasks wdt
844: WHERE mcce.cycle_count_header_id = p_cycle_count_header_id
845: AND mcce.cycle_count_entry_id = wdt.transaction_temp_id
846: AND mcce.organization_id = p_organization_id
847: AND mcce.subinventory = p_subinventory

Line 884: -- for these entries if a record in wms_dispatched_tasks exists,

880: -- Initialize the message stack
881: FND_MSG_PUB.initialize;
882:
883: -- To fetch the cycle count entry ids which are in status 2,4,5.
884: -- for these entries if a record in wms_dispatched_tasks exists,
885: -- it has to be deleted
886:
887: OPEN cc_entry_cursor;
888: LOOP

Line 897: DELETE FROM wms_dispatched_tasks wdt

893: print_debug ( 'Approval Pending/ Rejected/ Completed cycle count entries found' );
894: print_debug( 'Cycle count Entry Id: ' || l_cycle_count_entry_id);
895: END IF;
896: BEGIN
897: DELETE FROM wms_dispatched_tasks wdt
898: WHERE wdt.transaction_temp_id = l_cycle_count_entry_id;
899: IF ( l_debug = 1 ) THEN
900: print_debug('** Deleted wms_dispatched_tasks record with transaction_temp_id : ' || l_cycle_count_entry_id);
901: END IF;

Line 900: print_debug('** Deleted wms_dispatched_tasks record with transaction_temp_id : ' || l_cycle_count_entry_id);

896: BEGIN
897: DELETE FROM wms_dispatched_tasks wdt
898: WHERE wdt.transaction_temp_id = l_cycle_count_entry_id;
899: IF ( l_debug = 1 ) THEN
900: print_debug('** Deleted wms_dispatched_tasks record with transaction_temp_id : ' || l_cycle_count_entry_id);
901: END IF;
902: EXCEPTION
903: WHEN OTHERS THEN
904: IF ( l_debug = 1 ) THEN

Line 905: print_debug('Deleting wms_dispatched_tasks record failed');

901: END IF;
902: EXCEPTION
903: WHEN OTHERS THEN
904: IF ( l_debug = 1 ) THEN
905: print_debug('Deleting wms_dispatched_tasks record failed');
906: END IF;
907: END;
908: ELSE
909: IF ( l_debug = 1 ) THEN

Line 9059: FROM wms_dispatched_tasks wdt

9055:
9056: CURSOR completed_tasks_cursor
9057: IS
9058: SELECT wdt.transaction_temp_id
9059: FROM wms_dispatched_tasks wdt
9060: WHERE wdt.person_id = l_employee_id
9061: AND wdt.task_type = 3
9062: AND NOT EXISTS (
9063: SELECT 'ACTIVE_TASK'

Line 9081: FROM wms_dispatched_tasks_history

9077:
9078: -- Get the employee ID first for the person that performed the task
9079: SELECT DISTINCT NVL ( person_id, -999 )
9080: INTO l_employee_id
9081: FROM wms_dispatched_tasks_history
9082: WHERE transaction_id = p_transaction_temp_id AND task_type = 3;
9083:
9084: IF ( l_debug = 1 ) THEN
9085: print_debug ( 'The employee ID is: ' || l_employee_id );

Line 9113: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY

9109: IF ( l_debug = 1 ) THEN
9110: print_debug ( 'Inserting record into tasks history table' );
9111: END IF;
9112:
9113: INSERT INTO WMS_DISPATCHED_TASKS_HISTORY
9114: ( task_id,
9115: transaction_id,
9116: organization_id,
9117: user_task_type,

Line 9193: FROM WMS_DISPATCHED_TASKS

9189: attribute15,
9190: task_type,
9191: priority,
9192: task_group_id
9193: FROM WMS_DISPATCHED_TASKS
9194: WHERE TRANSACTION_TEMP_ID = l_task_temp_id AND TASK_TYPE = 3;
9195:
9196: l_progress := '40';
9197:

Line 9204: DELETE FROM WMS_DISPATCHED_TASKS

9200: print_debug ( 'Deleting the record from the dispatched tasks table'
9201: );
9202: END IF;
9203:
9204: DELETE FROM WMS_DISPATCHED_TASKS
9205: WHERE TRANSACTION_TEMP_ID = l_task_temp_id AND TASK_TYPE = 3;
9206: END LOOP;
9207:
9208: l_progress := '50';