eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_ACTION_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 149


		SELECT  DISTINCT transaction_temp_id
		FROM	wms_waveplan_tasks_temp
		WHERE	task_type_id = p_task_type_id;

Line: 184


PROCEDURE UPDATE_TASK
(	x_return_status		OUT NOCOPY	VARCHAR2,
	x_return_message	OUT NOCOPY	VARCHAR2
)
IS
	l_transaction_temp_id_tbl	wms_waveplan_tasks_pvt.transaction_temp_table_type;

Line: 201


		SELECT	distinct to_number(wwtt.task_type_id) task_type_id,
			mfl.meaning
		FROM	wms_waveplan_tasks_temp wwtt,
			mfg_lookups mfl
		WHERE	wwtt.task_type_id = mfl.lookup_code
		AND	mfl.lookup_type = 'WMS_TASK_TYPES';

Line: 208


	DEBUG( 'Inside UPDATE_TASK');

Line: 243


		DEBUG( 'No of tasks to be updated = ' || l_transaction_temp_id_tbl.count );

Line: 247


			/* Bug 5485730 - The employee details should be null if the status is being updated
			                 to Pending or Unreleased */
			IF l_status_code IN (1,8) THEN
			  l_employee	         := NULL;

Line: 260


			--call update task
			DEBUG( 'Calling WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK');

Line: 273


			DEBUG( 'p_update_priority_type	=> ' || l_priority_type);

Line: 274


			DEBUG( 'p_update_priority	=> ' || l_priority);

Line: 284


			wms_waveplan_tasks_pvt.update_task
			(
				p_transaction_temp_id	=> l_transaction_temp_id_tbl,
				p_task_type_id		=> l_task_type_id_table,
				p_employee		=> l_employee,
				p_employee_id		=> l_employee_id,
				p_user_task_type	=> l_user_task_type,
				p_user_task_type_id	=> l_user_task_type_id,
				p_effective_start_date	=> l_effective_start_date,
				p_effective_end_date	=> l_effective_end_date,
				p_person_resource_id	=> l_person_resource_id,
				p_person_resource_code	=> l_person_resource_code,
				p_force_employee_change	=> l_override_emp_check,
				p_to_status		=> l_status,
				p_to_status_id		=> l_status_code,
				p_update_priority_type	=> l_priority_type,
				p_update_priority	=> l_priority,
				p_clear_priority	=> l_clear_priority,
				x_result		=> l_result,
				x_message		=> l_message,
				x_task_id		=> l_task_id,
				x_return_status		=> l_return_status,
				x_return_msg		=> l_return_msg,
				x_msg_count		=> l_msg_count
			);

Line: 310


                        DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK return status = '|| l_return_status );

Line: 311


			DEBUG( 'WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK return message = '|| l_return_msg );

Line: 313


			DEBUG( 'No of tasks updated = ' || l_task_id.count );

Line: 318


				DEBUG (' Error in WMS_WAVEPLAN_TASKS_PVT.UPDATE_TASK ' || l_return_msg );

Line: 320


				x_return_message:= 'Error in wms_waveplan_tasks_pvt.update_task. '
							|| 'Error message is ' || l_return_msg;

Line: 329


	DEBUG( 'Exiting UPDATE_TASK');

Line: 335


		x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.UPDATE_TASK. '
					|| 'Oracle error message is ' || SQLERRM ;

Line: 339


END UPDATE_TASK;

Line: 359


		SELECT	distinct to_number(wwtt.task_type_id) task_type_id,
			mfl.meaning
		FROM	wms_waveplan_tasks_temp wwtt,
			mfg_lookups mfl
		WHERE	wwtt.task_type_id = mfl.lookup_code
		AND	mfl.lookup_type = 'WMS_TASK_TYPES';

Line: 405


			--call update task
			DEBUG( 'Calling WMS_WAVEPLAN_TASKS_PVT.CANCEL_TASK');

Line: 965


PROCEDURE DELETE_TEMP_QUERY
(	p_query_name		IN		VARCHAR2,
	x_return_status		OUT NOCOPY	VARCHAR2,
	x_return_message	OUT NOCOPY	VARCHAR2
)
IS
BEGIN
	DEBUG( 'Inside DELETE_TEMP_QUERY');

Line: 975


		delete
		from	wms_saved_queries
		where	query_name = p_query_name
		and	query_type = 'TEMP_TASK_PLANNING';

Line: 980


		DEBUG( 'Temporary query records cleaned. Records deleted = ' || sql%rowcount );

Line: 987


					|| 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '
					|| 'Oracle error message is ' || SQLERRM;

Line: 991


				|| 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY. '
				|| 'Oracle error message is ' || SQLERRM
				, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error'
			);

Line: 999


	DEBUG( 'Exiting DELETE_TEMP_QUERY');

Line: 1004


		x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY '
					|| 'Oracle error message is ' || SQLERRM;

Line: 1007


			||SQLERRM, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_QUERY - other error');

Line: 1008


END DELETE_TEMP_QUERY;

Line: 1010


PROCEDURE DELETE_TEMP_ACTION
(	p_action_name		IN		VARCHAR2,
	x_return_status		OUT NOCOPY	VARCHAR2,
	x_return_message	OUT NOCOPY	VARCHAR2
)
IS
BEGIN
	DEBUG( 'Inside DELETE_TEMP_ACTION');

Line: 1020


		delete
		from	wms_saved_queries
		where	query_name = p_action_name
		and	query_type = 'TEMP_TASK_ACTION';

Line: 1025


		DEBUG( 'Temporary action records cleaned. Records deleted = ' || sql%rowcount );

Line: 1033


					|| 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '
					|| 'Oracle error message is ' || SQLERRM;

Line: 1037


				|| 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION. '
				, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error'
			);

Line: 1044


	DEBUG( 'Exiting DELETE_TEMP_ACTION');

Line: 1049


		x_return_message:= 'Unexpected error has occured in WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION '
					|| 'Oracle error message is ' || SQLERRM;

Line: 1052


			||SQLERRM, 'WMS_TASK_ACTION_PVT.DELETE_TEMP_ACTION - other error');

Line: 1053


END DELETE_TEMP_ACTION;

Line: 1117


			DEBUG( 'Calling DELETE_TEMP_QUERY');

Line: 1119


			DELETE_TEMP_QUERY
			(
				p_query_name => p_query_name,
				x_return_status => l_return_status,
				x_return_message => l_return_message
			);

Line: 1126


			DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );

Line: 1127


			DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );

Line: 1140


			DEBUG( 'Calling DELETE_TEMP_ACTION');

Line: 1142


                       	DELETE_TEMP_ACTION
			(
				p_action_name => p_action_name,
				x_return_status => l_return_status,
				x_return_message => l_return_message
			);

Line: 1149


			DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );

Line: 1150


			DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );

Line: 1198


				DEBUG( 'Calling DELETE_TEMP_QUERY');

Line: 1200


            DELETE_TEMP_QUERY
				(
					p_query_name => p_query_name,
					x_return_status => l_return_status,
					x_return_message => l_return_message
				);

Line: 1206


				DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );

Line: 1207


				DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );

Line: 1220


				DEBUG( 'Calling DELETE_TEMP_ACTION');

Line: 1222


                        	DELETE_TEMP_ACTION
				(
					p_action_name => p_action_name,
					x_return_status => l_return_status,
					x_return_message => l_return_message
				);

Line: 1229


				DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );

Line: 1230


				DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );

Line: 1247


		DEBUG( 'Calling DELETE_TEMP_QUERY');

Line: 1248


			DELETE_TEMP_QUERY
		(
			p_query_name => p_query_name,
			x_return_status => l_return_status,
			x_return_message => l_return_message
		);

Line: 1254


		DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );

Line: 1255


		DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );

Line: 1268


		DEBUG( 'Calling DELETE_TEMP_ACTION');

Line: 1269


		DELETE_TEMP_ACTION
		(
			p_action_name => p_action_name,
			x_return_status => l_return_status,
			x_return_message => l_return_message
		);

Line: 1275


		DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );

Line: 1276


		DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );

Line: 1314


		select	field_name,
			--ltrim(rtrim(field_value)) field_value,
			field_value,
			organization_id,
			query_type
		from	wms_saved_queries
		where	query_name = p_query_name
		and	(query_type = 'TASK_PLANNING' or query_type = 'TEMP_TASK_PLANNING')
		FOR UPDATE NOWAIT;

Line: 1325


		select	field_name,
			field_value,
			query_type
		from	wms_saved_queries
		where	query_name = p_action_name
		and	(query_type = 'TASK_ACTION' or query_type = 'TEMP_TASK_ACTION')
		FOR UPDATE NOWAIT;

Line: 1334


		select	distinct query_type
		from	wms_saved_queries
		where	query_name = p_action_name;

Line: 1841


	l_field_name_table.delete;

Line: 1842


	l_field_value_table.delete;

Line: 1843


	l_query_type_table.delete;

Line: 1909


	DEBUG ( 'No of eligible tasks to be updated are ' || l_field_name_table.count );

Line: 1915


			DEBUG( 'Calling UPDATE_TASK');

Line: 1917


         UPDATE_TASK
			(	x_return_status => l_return_status,
				x_return_message=> l_return_message
			);

Line: 1925


				DEBUG (' Error in UPDATE_TASK ' );

Line: 1927


				x_return_message:= 'UPDATE_TASK returned with Error status'
							|| 'Error message is ' || l_return_message;

Line: 1967


			DEBUG( 'Calling DELETE_TEMP_QUERY');

Line: 1968


				DELETE_TEMP_QUERY
			(
				p_query_name => p_query_name,
				x_return_status => l_return_status,
				x_return_message => l_return_message
			);

Line: 1975


			DEBUG( 'DELETE_TEMP_QUERY return status = ' || l_return_status );

Line: 1976


			DEBUG( 'DELETE_TEMP_QUERY return message = ' || l_return_message );

Line: 1988


			DEBUG( 'Calling DELETE_TEMP_ACTION');

Line: 1989


			DELETE_TEMP_ACTION
			(
				p_action_name => p_action_name,
				x_return_status => l_return_status,
				x_return_message => l_return_message
			);

Line: 1996


			DEBUG( 'DELETE_TEMP_ACTION return status = ' || l_return_status );

Line: 1997


			DEBUG( 'DELETE_TEMP_ACTION return message = ' || l_return_message );