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: 153


		SELECT  DISTINCT transaction_temp_id
		FROM	wms_waveplan_tasks_temp
		WHERE	task_type_id = p_task_type_id;

Line: 188


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: 205


		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: 212


	DEBUG( 'Inside UPDATE_TASK');

Line: 247


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

Line: 251


			/* 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: 264


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

Line: 277


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

Line: 278


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

Line: 288


			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: 314


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

Line: 315


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

Line: 317


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

Line: 322


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

Line: 324


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

Line: 333


	DEBUG( 'Exiting UPDATE_TASK');

Line: 339


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

Line: 343


END UPDATE_TASK;

Line: 363


		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: 409


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

Line: 990


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: 1000


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

Line: 1005


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

Line: 1012


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

Line: 1016


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

Line: 1024


	DEBUG( 'Exiting DELETE_TEMP_QUERY');

Line: 1029


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

Line: 1032


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

Line: 1033


END DELETE_TEMP_QUERY;

Line: 1035


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: 1045


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

Line: 1050


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

Line: 1058


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

Line: 1062


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

Line: 1069


	DEBUG( 'Exiting DELETE_TEMP_ACTION');

Line: 1074


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

Line: 1077


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

Line: 1078


END DELETE_TEMP_ACTION;

Line: 1142


			DEBUG( 'Calling DELETE_TEMP_QUERY');

Line: 1144


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

Line: 1151


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

Line: 1152


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

Line: 1165


			DEBUG( 'Calling DELETE_TEMP_ACTION');

Line: 1167


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

Line: 1174


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

Line: 1175


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

Line: 1223


				DEBUG( 'Calling DELETE_TEMP_QUERY');

Line: 1225


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

Line: 1231


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

Line: 1232


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

Line: 1245


				DEBUG( 'Calling DELETE_TEMP_ACTION');

Line: 1247


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

Line: 1254


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

Line: 1255


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

Line: 1272


		DEBUG( 'Calling DELETE_TEMP_QUERY');

Line: 1273


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

Line: 1279


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

Line: 1280


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

Line: 1293


		DEBUG( 'Calling DELETE_TEMP_ACTION');

Line: 1294


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

Line: 1300


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

Line: 1301


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

Line: 1339


		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: 1350


		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: 1359


		select	distinct query_type
		from	wms_saved_queries
		where	query_name = p_action_name;

Line: 1872


	l_field_name_table.delete;

Line: 1873


	l_field_value_table.delete;

Line: 1874


	l_query_type_table.delete;

Line: 1940


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

Line: 1946


			DEBUG( 'Calling UPDATE_TASK');

Line: 1948


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

Line: 1956


				DEBUG (' Error in UPDATE_TASK ' );

Line: 1958


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

Line: 1998


			DEBUG( 'Calling DELETE_TEMP_QUERY');

Line: 1999


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

Line: 2006


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

Line: 2007


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

Line: 2019


			DEBUG( 'Calling DELETE_TEMP_ACTION');

Line: 2020


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

Line: 2027


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

Line: 2028


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