APPS.AHL_PC_HEADER_PUB SQL Statements

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

Line: 26

			SELECT LOOKUP_CODE , MEANING
			FROM  FND_LOOKUP_VALUES_VL
			WHERE LOOKUP_TYPE = p_lookup_type
			AND MEANING LIKE NVL(p_lookup_meaning,'%')
			AND LOOKUP_CODE LIKE NVL(p_lookup_code,'%');

Line: 60

		IF (p_x_pc_header_rec.OPERATION_FLAG <> AHL_PC_HEADER_PVT.G_DML_DELETE)
		THEN
			p_x_pc_header_rec.NAME := TRIM(p_x_pc_header_rec.NAME);

Line: 121

		select lookup_code, meaning
		from fnd_lookup_values_vl
		where lookup_type = 'ITEM_TYPE' and
		      upper(meaning) = upper(p_pc_item_type_desc) and
		      view_application_id = 3 and
		      enabled_flag = 'Y' and
		      sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active, sysdate);

Line: 131

		select lookup_code, meaning
		from fnd_lookup_values_vl
		where lookup_type = 'ITEM_TYPE' and
		      upper(meaning) = upper(p_pc_item_type_desc) and
		      lookup_code = p_pc_item_type_code and
		      view_application_id = 3 and
		      enabled_flag = 'Y' and
		      sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active, sysdate);

Line: 240

		-- If module type is JSP (or undefined), and it is not Delete PC operation
		-- Then item_type_desc should be converted to item_type_code
		-- Also nullify status_desc, association_type_desc, primary_flag_desc -- no scenario where these values will change through some user-action
		IF ( p_module_type = 'JSP' OR p_module_type IS NULL ) AND
		   ( p_x_pc_header_rec.operation_flag <> AHL_PC_HEADER_PVT.G_DML_DELETE )
		THEN
			CONVERT_ITEM_TYPE_DESC_TO_CODE (p_x_pc_header_rec);

Line: 285

		ELSIF (p_x_pc_header_rec.operation_flag = AHL_PC_HEADER_PVT.G_DML_UPDATE)
		THEN
			IF G_DEBUG='Y' THEN
		  		AHL_DEBUG_PUB.debug('PCH -- PUB -- Calling UPDATE_PC_HEADER for ID='||p_x_pc_header_rec.PC_HEADER_ID);

Line: 291

			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_FALSE,
				p_validation_level      => p_validation_level,
				p_x_pc_header_rec	=> p_x_pc_header_rec,
				x_return_status         => x_return_status,
				x_msg_count             => x_msg_count,
				x_msg_data              => x_msg_data
			);

Line: 319

		ELSIF (p_x_pc_header_rec.operation_flag = AHL_PC_HEADER_PVT.G_DML_DELETE)
		THEN
			IF G_DEBUG='Y' THEN
		  		AHL_DEBUG_PUB.debug('PCH -- PUB -- Calling DELETE_PC_HEADER for ID='||p_x_pc_header_rec.PC_HEADER_ID);

Line: 325

			AHL_PC_HEADER_PVT.DELETE_PC_HEADER
			(
				p_api_version           => 1.0,
				p_init_msg_list         => FND_API.G_FALSE,
				p_commit                => FND_API.G_FALSE,
				p_validation_level      => p_validation_level,
				p_x_pc_header_rec	=> p_x_pc_header_rec,
				x_return_status         => x_return_status,
				x_msg_count             => x_msg_count,
				x_msg_data              => x_msg_data
			);