APPS.AHL_PC_APPROVAL_PVT SQL Statements

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

Line: 32

		select PC_HEADER_ID, name
		from AHL_pc_headers_b
		where PC_HEADER_ID = c_pc_header_id;

Line: 326

		select PC_HEADER_ID,Name
		from AHL_PC_headers_b
		where PC_HEADER_ID=c_pc_header_id;

Line: 456

		select PC_HEADER_ID,Name
		from AHL_PC_headers_b
		where PC_HEADER_ID=c_pc_header_id;

Line: 583

		select PC_HEADER_ID,Name
		from AHL_PC_headers_b
		where PC_HEADER_ID=c_pc_header_id;

Line: 704

		select PC_HEADER_ID,Name
		from AHL_PC_headers_b
		where PC_HEADER_ID=c_pc_header_id;

Line: 834

		select PC_HEADER_ID,Name
		from AHL_PC_headers_b
		where PC_HEADER_ID=c_pc_header_id;

Line: 973

		select PC_HEADER_ID,Name
		from AHL_PC_headers_b
		where PC_HEADER_ID=c_pc_header_id;

Line: 1108

		select PC_HEADER_ID,Name
		from AHL_PC_headers_b
		where PC_HEADER_ID=c_pc_header_id;

Line: 1154

		UPDATE AHL_PC_HEADERS_B
		SET STATUS='INVALID'
		WHERE PC_HEADER_ID=l_object_id;

Line: 1222

	PROCEDURE UPDATE_STATUS
	(
		 itemtype    IN       VARCHAR2
		,itemkey     IN       VARCHAR2
		,actid       IN       NUMBER
		,funcmode    IN       VARCHAR2
		,resultout   OUT    NOCOPY  VARCHAR2
	)
	IS

	l_error_msg                	VARCHAR2(4000);

Line: 1256

		SELECT *
		FROM AHL_PC_HEADERS_VL
		WHERE PC_HEADER_ID = c_pc_header_id;

Line: 1277

				,aname    => 'UPDATE_GEN_STATUS'
			);

Line: 1280

		  	  AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_approval_status='||l_approval_status);

Line: 1301

		  AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status='||l_next_status);

Line: 1315

		  	 AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number='||l_object_version_number);

Line: 1325

		  	 AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_id='||l_object_id);

Line: 1370

				AHL_PC_HEADER_PVT.UPDATE_PC_HEADER
				(
					p_api_version           => 1.0,
					p_init_msg_list         => FND_API.G_FALSE,
					p_commit                => FND_API.G_TRUE,
					p_validation_level      => FND_API.G_VALID_LEVEL_FULL,
					p_x_pc_header_rec	=> l_pc_header_rec,
					x_return_status         => x_return_status,
					x_msg_count             => x_msg_count,
					x_msg_data              => x_msg_data
				);

Line: 1382

		  		 AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- Completed AHL_PC_HEADER_PVT.UPDATE_PC_HEADER');

Line: 1437

				'UPDATE_STATUS',
				itemtype,
				itemkey,
				actid,
				funcmode,
				l_error_msg
			);

Line: 1449

				'UPDATE_STATUS',
				itemtype,
				itemkey,
				actid,
				funcmode,
				l_error_msg
			);

Line: 1458

	END UPDATE_STATUS;

Line: 1482

		select PC_HEADER_ID,Name
		from AHL_PC_headers_b
		where PC_HEADER_ID=c_pc_header_id;

Line: 1507

		  	 AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_next_status'||l_next_status);

Line: 1517

		  		AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_version_number'||l_object_version_number);

Line: 1527

		  	 AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- l_object_id'||l_object_id);

Line: 1532

			UPDATE AHL_PC_HEADERS_B
			SET STATUS = 'DRAFT',
			    OBJECT_VERSION_NUMBER = l_object_version_number + 1
			WHERE PC_HEADER_ID = l_object_id AND
			      OBJECT_VERSION_NUMBER = l_object_version_number;

Line: 1539

		  	 AHL_DEBUG_PUB.debug('PCWF -- UPDATE_STATUS -- Completed reset of status');